Validation Rule

Resolved · Low Priority · Version 2000

Wed 22 Feb 2012, 14:02 Delegate 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:37 Trainer 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 courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips