Text field in table

[wildexodus]

I want to make one of my text fields in a table only allow text entry. I know i need to put something in the 'validation rule' box but what is the codes?

 

[jfgambit]

Have you tried:

>L<?????????????? in the Validation Rule

Give it a whirl

 

[wildexodus]

Doesnt work. Says ive put in an operand without a valid operator.

 

[jfgambit]

Just to confirm, by "text" entry you mean you only want Alpha Characters and no Numeric? Yes?

 

[Mile-O]

If you don't want numbers then you can put:

IsNumeric([YourField])=False


If you only want the letters A through Z:

Asc([YourField]) Between 64 And 122


If you want letters A through Z and the space:

Asc([YourField]) Between 64 And 122 Or Asc([YourField])=32

 

[wildexodus]

where should i put that thought, because it doesnt seem to work in the validation rule of the table field properties. Does it have to go in the VBA code?

 

[Mile-O]

When I tried all three of them, they worked in the Validation Rule of the field.

Might be patronising here but...did you exchange [YourField] to the actual name of your field?

 

[wildexodus]

No its not patronising but i did change it. Never mind.