Data entry in upper case

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to set the database so that all data entry into my forms is
upper case? Is there a global way to set this or is it something that needs
to be set at the form level? Any help is greatly appreciated!

Thanks
 
You can set the Format property for each (Text) n the table to display as
Upper Case by using the > symbol. Note that this does not actually convert to
Upper Case but does display as Upper. By setting it in the table it should
carry through to each form, report etc. If that's not what you want then set
the Format property in the individual Form, Reports, etc.
HTH - Sheila
 
Sorry - had Insert on - should say
You can set the Format property for each (Text) FIELD IN the table to
display as
Upper Case by using the > symbol. Note that this does not actually convert to
Upper Case but does display as Upper. By setting it in the table it should
carry through to each form, report etc. If that's not what you want then set
the Format property in the individual Form, Reports, etc.
HTH - Sheila
 
Lori said:
Is there any way to set the database so that all data entry into my
forms is upper case? Is there a global way to set this or is it
something that needs to be set at the form level? Any help is
greatly appreciated!

Thanks
Click to expand...

Got to ask. Why do you want all upper case?
 
Thanks for your help - this worked great!

Sheila D said:
Sorry - had Insert on - should say
You can set the Format property for each (Text) FIELD IN the table to
display as
Upper Case by using the > symbol. Note that this does not actually convert to
Upper Case but does display as Upper. By setting it in the table it should
carry through to each form, report etc. If that's not what you want then set
the Format property in the individual Form, Reports, etc.
HTH - Sheila
Click to expand...
 
The people using the database want to ensure that all of their reports are
uniform and want it all upper case. Not my choice. :-)
 
Lori said:
The people using the database want to ensure that all of their
reports are uniform and want it all upper case. Not my choice. :-)
Click to expand...

I was afraid of that.

Lucky for me, I was always in a position to say, sorry, we are not going
to do that.... and I always got away with it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Data Entry Setting 0
Upper Case 1
distinguish upper/lower case in unique index? 4
Coverting Upper Case to Lower Case 1
I would like all upper case in a field........ 4
Change all upper case letters to lower case 2
Formatting cells to only upper case 5
Formatting upper or lower case text 3

Back
Top