Field Rules

[darrellx]

Is it possible to set up a rule in a field so that it will only accept or auto correct all words to display in capital letters?



If so, how do I do this.

Thanks

darrellx

[ajetrumpet]

look up "mask" in access help.

example field mask that req's uppercase:

>LLLLLLLLLLLLLLLLLLLLLLLLLLLL

[rpeare]

you can also, in a query or form or report use

UCASE([FieldName])

the UCASE function converts all alpha characters to upper case.

[darrellx]

Dear Ajetrumpet:

I input the code for the input mask like you have it >LLLLLLLLLLLLLLLLLLLLLLLL and when I try to save it, I get a message:

"The value you entered isn't appropriate for the input mask '>LLLLLLLLLLLLLLLLLLLLL;0; specified for this field"

What am I doing wrong?

Thanks

Darrellx

[ajetrumpet]

Dear Ajetrumpet:

I input the code for the input mask like you have it >LLLLLLLLLLLLLLLLLLLLLLLL and when I try to save it, I get a message:

"The value you entered isn't appropriate for the input mask '>LLLLLLLLLLLLLLLLLLLLL;0; specified for this field"

What am I doing wrong?

Thanks

Darrellx

did you look at the help article? "L" is the mask for a MANDATORY character. Hence, the value has to be that amount of "L"'s long or it'll error. If you can't figure the mask out, try the other suggestion and change the value entered to UCASE() via code when a new record button is clicked.

[darrellx]

Figured it out. Thanks ajetrumpet