Changing case of a table field

[Kundan]

How to convert a field of a table to UPPER CASE, lower case, Proper case, through program?

[June7]

Use UCase(), LCase(), StrConv() functions.

Do you want to actually change the saved data? Run UPDATE action.

Review http://www.databasedev.co.uk/access-...functions.html

[orange]

Do you want to change the case of table field values OR table field names?

For table field names see this link.

[June7]

Don't advise all one case for naming convention - harder to read. Also advise no spaces nor punctuation/special characters (underscore only exception).

[Kundan]

Use UCase(), LCase(), StrConv() functions.

Do you want to actually change the saved data? Run UPDATE action.

Review http://www.databasedev.co.uk/access-...functions.html

Thanks!!! God Bless You!
Could you suggest some sites where I can find schemas of different projects like Guest House Mngt., Stock Mngt. etc.

[orange]

For free, generic data models and tutorials and other data management articles see Barry Williams' site.

[Kundan]

For free, generic data models and tutorials and other data management articles see Barry Williams' site.

I have prepared a form, but when I press the form itself moves up & down.How to keep it fixed & only let records move forward & backward? The form properties [Scroll Bar] is (Neither) & [Movable] is (No).

[Kundan]

For free, generic data models and tutorials and other data management articles see Barry Williams' site.

When we open a report in Layout View the conditional formatting doesn't work even after selecting a value in the Report. What is the reason and how to solve it?

[isladogs]

Layout view is only intended for fine-tuning the layout. Use print preview

[Kundan]

Layout view is only intended for fine-tuning the layout. Use print preview

I want to apply conditional formatting to a report. The conditional formatting button is active but when I click it the Conditional Formatting Rules Managerwindow does not appear. WAHAT TO DO?