<ts*****@cetusgroup.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
I need to define a field so that when a lowercase letter is put in the
field it turns to an uppercase letter. What would the expression for
the field be? My field name is site_id.
The simplest way to do this is in the design of the table, select the field
and into the format property write ">" (without the quotes, ie >).
This will not change the data as lower case letters will still be held in
the table, it just forces them to appear as upper case. If you have to make
sure that no lower case letters are entered into the table, then the only
way is to write code in the form where you enter the data. However, the
solution above is quick, simple and may do all you require.