force uppercase

[cacacaconnie]

I know that in table, general tab, format > will force uppercase. When I view
my data from the table all is uppercase, but when I query out this
information to a form it displays exactly the way I typed it. If I typed it
lowercase it displays lowercase, how do I control the output display here?

 

[Al Campagna]

cacacaconnie,
Use the Format property for the text control on the form...just the same as the table.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[cacacaconnie]

Thanks for the info....I am pulling this information (state) using an
expression in a query through a combo box, then using the column function to
display to information. Is there a way to format this without changing the
entire address to uppercase?

 

[fredg]

I know that in table, general tab, format > will force uppercase. When I view
my data from the table all is uppercase, but when I query out this
information to a form it displays exactly the way I typed it. If I typed it
lowercase it displays lowercase, how do I control the output display here?

Use a form for data entry (never a table!).
Code the Control's AfterUpdate event:
Me![ControlName] = UCase([ControlName])

This will store the data in upper case.

Existing data, however will not be changed.
To change existing data, run an Update query.

Update MyTable Set MyTable.[FieldName] = UCase([FieldName])

 

[Al Campagna]

You don't say whether you've concatenated the State in your combo column, or whether
State is in it's own column.
If State is in it's own column use a calculated field to display the State
CapState : UCase(State)
If concatenated with other fields...
CapState : [City] & ", " & UCase(State)

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."