Validation Rulein Tabel !

Ossama22

New Member
Joined
Aug 31, 2018
Messages
2
Hello ,

I Have a Tabel which there are alot of cells , for Example i have 2 cells which i wanna to make a validation rule between them : Account Number & Clearance Code

i wanna to create a rule if the clearance code = any value , when i try to write any account number it shows a msg that we cannot add account number because there's a value in clearance code . is that possible in Microsoft Access Table ?

Thx for your support
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
I don't think we have this available at the table level in Access.
You could use code in an Access form to check values as you enter them, using the after update events of the form controls.
This gets a little tricky (what if clearance code is entered by the user before account code, or vice versa). Anytime you start trying to validate user entry its gets ugly fast as users will do all kinds of ridiculous things. You might want to, for instance, disable the account field as soon as the clearance field is entered, and vice versa if it is cleared, so as to make it harder to do the wrong thing.
 
Upvote 0

Forum statistics

Threads
1,213,562
Messages
6,114,326
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top