access Validation rules

[ac_angel]

pls help

i am trying to make a validation rule

that only allows numbers to be entered into a field

also i want to find out how to get it to only allow letters too.

any help would be helpful thank u

*Angel*

 

[PARSO]

for numbers only just set the data type to 'number'

not sure about the text only,

 

[kim242]

<>0 is a simple way to force the number to be a nonzero value

As said above you can just choose "number" or "text" for the data type

And does anyone know the validation rule for all capital letters, I can't seem to rembember it

 

[ghudson]

Search for the keyword "keypress". I have posted samples of how to use the KeyPress event to only allow specific keys to be pressed within a text box.

 

[chef_tim]

<>0 is a simple way to force the number to be a nonzero value

As said above you can just choose "number" or "text" for the data type

And does anyone know the validation rule for all capital letters, I can't seem to rembember it

I used the format ">" in Access 03.