This is pretty simple but I need to place a validation rule in my table for a field so that users can only enter data that starts with APB
What would the rule be?
Novice
Windows 7 64bit 
Access 2007
This is pretty simple but I need to place a validation rule in my table for a field so that users can only enter data that starts with APB
What would the rule be?
VIP
Windows XP Access 2010 32bit
You want to make users have to repeatedly type APB? What is the rest of the value like? Would an input mask be better?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
IIf in Validation Rule
Validation Rule
Validation Rule
Posting Permissions
Reply With Quote