Forcing capitalisation in exported table

medalert

New member
Local time
Tomorrow, 07:44
Joined
Mar 21, 2013
Messages
4
Hi,
Hope this is the correct section... it covers a bit more than just tables.

We have a large health database, with several data entry individuals, that has run for many years.

I use input mask >aC to force the table entries to appear as though sex is F or M even if entered accidently or in the past as "f" or "m" and also >aCCCCCCCCCC to make all names consistently in capitals.

I use > in formatting to be sure reports from the table are printed as capitals.

Access looks wonderful :)

Frustrating me is that when I export the Access database into my statictics program for analysis, physically what was originally entered is exported e.g Smith, SMITH, smith, smiTH. I want it to appear as only SMITH in my export.

Currently to data clean, I remove the masks and physically go through the data to ensure consistency before exporting.

Is there anyway other than this?

Cheers
Alex
 
Create a query and derive the fields with UCase() to convert them to capitals. Export the query.

If you would prefer the data be stored as upper case then use the BeforeUpdate event of the control to convert the controls' Text to Uppercase.
 
Formatting only changes appearance as you have seen. What you need to do is store the uppercase.

Search UCase in Access Help for more information.

As Galaxiom said use the BeforeUpdate event of the control.
 

Users who are viewing this thread

Back
Top Bottom