Field size

K

kevcar40

Hi
I have a field call part number
the part number is entered into a text box on a form

How can i
1. make it compusary that 12 characters are entered

2 Stop empty spaces in the string


thanks

kevin
 
A

Allen Browne

1, Open the table in design view.

2. Select the field.

3. In the lower pane, set the Validation Rule to:
Like "????????????" And Not Like "* *"
 
Top