Ucase

  • Thread starter Thread starter nchelo
  • Start date Start date
N

nchelo

I have a field "State" that I want to restrict to uppercase.

Should this be done in forms under properties for validation rule or
should this be done in forms under validation rule. Does it make a
difference? Are these one in the same?

In tables I used the following expression UCase([State]) yet this did
not prevent me from entering lower case. I am a new access user, what
am I missing that this won't work?
 
How you do this depends on whether or not you want the data
permanently stored that way or not. To force Uppercase for
display purposes put '>' in the Format line. If you want to
permanently store it that way put the following into the
AfterUpdate event of the form control...

Me!State = UCase([State])

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Great that worked but led to another problem. If I type in wa as the state and then tab forward it appears as "WA Why does this quote show up?

Also, Should this be done in forms under properties for
validation rule or
Click to expand...

Gary Miller said:
How you do this depends on whether or not you want the data
permanently stored that way or not. To force Uppercase for
display purposes put '>' in the Format line. If you want to
permanently store it that way put the following into the
AfterUpdate event of the form control...

Me!State = UCase([State])

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
nchelo said:
I have a field "State" that I want to restrict to uppercase.

Should this be done in forms under properties for validation rule or
should this be done in forms under validation rule. Does it make a
difference? Are these one in the same?

In tables I used the following expression UCase([State]) yet this did
not prevent me from entering lower case. I am a new access user, what
am I missing that this won't work?
Click to expand...
Click to expand...
 
Did you include any of the quotes that I surrounded the >
with? Should just be >

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
Great that worked but led to another problem. If I type in
wa as the state and then tab forward it appears as "WA Why
does this quote show up?

Also, Should this be done in forms under properties for
validation rule or Does
it make a
Click to expand...

Gary Miller said:
How you do this depends on whether or not you want the data
permanently stored that way or not. To force Uppercase for
display purposes put '>' in the Format line. If you want to
permanently store it that way put the following into the
AfterUpdate event of the form control...

Me!State = UCase([State])

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
nchelo said:
I have a field "State" that I want to restrict to uppercase.

Should this be done in forms under properties for validation rule or
should this be done in forms under validation rule.
Click to expand...
Does
it make a
difference? Are these one in the same?

In tables I used the following expression UCase([State]) yet this did
not prevent me from entering lower case. I am a new access user, what
am I missing that this won't work?
Click to expand...
Click to expand...
 
Back
Top