Update Query to Force Field to Uppercase in Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create an update query that takes the value of one field
(INSCRIPTION) and updates the value of another field (LANDOWNER) in such a
way that whatever is in the INSCRIPTION field is stored in LANDOWNER field as
ALL UPPER CASE LETTERS. I know how to format the field in the query and in
the table (using properties), but this does not result in the data being
stored in ALL CAPS. It just results in it being DISPLAYED as all caps. In
fact, I want it to store the data in ALL CAPS, but the table needs to allow
the user to change the data to mixed case at will. Hopefully, this
explanation makes sense to someone who knows how to address it. Thanks!
 
I want to create an update query that takes the value of one field
(INSCRIPTION) and updates the value of another field (LANDOWNER) in such a
way that whatever is in the INSCRIPTION field is stored in LANDOWNER field as
ALL UPPER CASE LETTERS. I know how to format the field in the query and in
the table (using properties), but this does not result in the data being
stored in ALL CAPS. It just results in it being DISPLAYED as all caps. In
fact, I want it to store the data in ALL CAPS, but the table needs to allow
the user to change the data to mixed case at will. Hopefully, this
explanation makes sense to someone who knows how to address it. Thanks!
Click to expand...

While it's easy enough to store the data in all caps in the other
field, it's not a very good idea.
Having the same data in 2 different fields will, at some point
(especially as the user can change the data) in having different data
in the 2 fields. Believe it or not, users do make mistrakes. <g>
A better solution is to retain the data in one field and simply use
UCase([FieldName]) whenever you wish to display it in upper case, or
StrConv([FieldName],3) whenever you wish to show it in Proper Case.
 
Back
Top