changing case

[leewisener]

When I import an excel file into access it changes the all the text to capitals even though it was all just Title case before.

Is there a way to maintain the case of data after it imports or too convert it back once its in.

If that makes sense.

Thanks

Lee

 

[ZmrAbdulla]

Hi,
Do you have any formating in the table level?
If there change it
Regards

Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com

 

[leewisener]

Checked several options related to the format of the table but cant find anything specific that allows the changing of case.

 

[CosmoKramer]

Two quick ways to change the display (provided you don't want to do this to too many fields) is to add a user defined field to your query and reference that field in your report:

FormattedPersonName: StrConv([PersonName],3)

or, add an unbound text box to your report and set the control source to something like this:

=StrConv([PersonName],3)

Hoc nomen meum verum non est.