Field size

[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

 

[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 "* *"