98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Validation Rule
Validation Rule
Resolved · Low Priority · Version 2000
Wed 22 Feb 2012, 14:02Delegate Katrina said...
Katrina has attended:
Access Introduction course
Access Intermediate course
Validation Rule
In Validation Rule, what would I write to restrict the text length to 8?
Thanks
Fri 24 Feb 2012, 09:37Trainer Anthony said...
RE: Validation Rule
Hi Katrina, thanks for your query. In the validation rule for the field in table design view put:
Like "????????"
...(where "?" represents 1 character) to force enter of exactly 8 characters. If you want a maximum of 8, just set the text length of the field to 8.
Hope this helps,
Anthony
Fri 2 Mar 2012: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Run with the totalOften when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses. |
