Formatting data in Access Records

[rob_andy]

I've got a load of records, most are in Upper/Lower formatting i.e Coventry. I have recently taken a fair amount of data from another database and that is in uppercase i.e COVENTRY. This is across a number of fields. Is there a quick way of converting all the upper case entries into Upper/Lower formatting. Thanks in advance for any help. R

 

[Philem]

Hullo. One assumes that you wish this formatting to happen in a report or forum. Use the Proper(fieldname) method as appropriate.

HTH

P

 

[rob_andy]

Its actually in the database, all the info is displayed via an access form at the moment so it need to display correctly in the form. Thanks R