Field size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kevcar40 - 15 Mar 2007 14:47 GMT

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

Reply to this Message

Allen Browne - 15 Mar 2007 16:31 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi
> I have a field call part number
[quoted text clipped - 4 lines]
>
> 2 Stop empty spaces in the string

Reply to this Message