Changing format properties in tables

  • Thread starter Thread starter Kay D.
  • Start date Start date
K

Kay D.

I've updated the formatting properties in one of my tables
to always display uppercase letters. Is there an easy way
to automatically update those fields in queries, forms and
reports?

Thank you in advance.
 
I've updated the formatting properties in one of my tables
to always display uppercase letters. Is there an easy way
to automatically update those fields in queries, forms and
reports?

Thank you in advance.
Click to expand...

You shouldn't be looking at the data in your table. Table's are for
storing data, not for viewing.

Formatting a field has no effect on the data stored in the field, just
how it is displayed. You can always format the form or report control
just as you have the table field to display the data in upper case.
Better yet, update the data in the table to actually be Upper Case.

Run an Update query to actually change the data to Upper case:

Update YourTable Set YourTable.FieldName = UCase([FieldName]) Where
Tablename.FieldName is not null;

After running the query, the data will stored in upper case.

To enter new data in upper case, via a Form, code the control's
AfterUpdate event:
Me![Controlname] = UCase([ControlName])

Then there is no longer any need for special formatting on your form
or in a report. The data is already upper case.
 
Why does a memo field revert to only 255 characters when I
format it to display uppercase?
-----Original Message-----
I've updated the formatting properties in one of my tables
to always display uppercase letters. Is there an easy way
to automatically update those fields in queries, forms and
reports?

Thank you in advance.
Click to expand...

You shouldn't be looking at the data in your table. Table's are for
storing data, not for viewing.

Formatting a field has no effect on the data stored in the field, just
how it is displayed. You can always format the form or report control
just as you have the table field to display the data in upper case.
Better yet, update the data in the table to actually be Upper Case.

Run an Update query to actually change the data to Upper case:

Update YourTable Set YourTable.FieldName = UCase ([FieldName]) Where
Tablename.FieldName is not null;

After running the query, the data will stored in upper case.

To enter new data in upper case, via a Form, code the control's
AfterUpdate event:
Me![Controlname] = UCase([ControlName])

Then there is no longer any need for special formatting on your form
or in a report. The data is already upper case.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top