Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2007

Emma has attended:
Access Intermediate course
Access Advanced course

Access 2007

How can I change a colum which has been typed in capitals to lower case?

RE: Access 2007

Hi Emma

Thank you for your question.

You can force any entry into lowercase by using an input mask of the form <###########. This will only work for new data

If you want to change existing data into lowercase then you wil need to build a query and create a calculated field.

Using the expression builder, click on the functions folder and select 2built in functions", select text function and double click on Lcase. You must then apply this function to the field in question.

Hope this is useful. Let me know if you need further clarification

Regards

Stephen

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.