Re: How can I require all-caps in a form field?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Bruce, I wonder if you realize that doesn't actually change the case?
It only affects the way Access displays it. Do a merge to Word (for example), and you see the uncased data.

There are a couple of other side effects to doing this also:
- It truncates the display of memo fields.
- There were bugs in A2003 SP3 where you got nothing displayed in a combo if the field had this format.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"BruceM" <bamoob@xxxxxxxxxxxxxxxx> wrote in message
news:uOCF6JzkIHA.2268@xxxxxxxxxxxxxxxxxxxxxxx
You could just set the format of the text box to >. That is, enter a Greater Than sign in the text box Format property. Let the users type using whatever format they choose; it will display as all caps.
You would have to apply the same format whenever you want the data displayed.
You could also convert the text using the UCase function. In the text box After Update event:
Me.YourField = UCase(Me.YourField)

"Theber" <Theber@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:D78487A9-F05B-401B-904C-BA40AA1A91DE@xxxxxxxxxxxxxxxx
I want users to enter the data in one field of my form in all caps. I can't
use a drop-down list, and don't think I can use an input mask as I don't know
anything about what the data will look like (how many characters, words,
punctuation, etc). I didn't see a relevant option on the properties for the
text box. Do I have to control it from the underlying table?

Basically, I'd like it to default to caps so that the user doesn't have to
think about it. Is this possible?

Thanks!


.

Relevant Pages

  • Re: Sum,Sort, Format, and Date Range
    ... it is best to let query's get the raw data & let the display ... Sum([COST DIECOST]) AS ... Format property, ...
    (microsoft.public.access.queries)
  • Re: Tapble top fusion generator
    ... >increased my monitor format to 1280x1024 and display it on a Mitsubishi ... >using a screen format less than 1280x1024 and the low -resolution LCD ... >Since the poster writing about the character overlap, ... is, when you make one web site viewable, you can render others ...
    (sci.physics.fusion)
  • 2 Ques regarding dates (matching and subtracting)
    ... The end-user enters a date in cell a2, validated to format DD/MM/YYYY. ... In K30, I want to display the number of days until the end of the month, ... "Jacob" wrote: ... > I want to use a subtraction or matching formula. ...
    (microsoft.public.excel.misc)
  • Re: Dividing hours
    ... you can display these in a format that mimics time by making use of the ... The divisional manager will enter in the annual planned hrs on the ... worksheets Each workbook also has a calculation worksheet. ...
    (microsoft.public.excel.misc)
  • Re: Create Dynamic Controls and Displaying Page by Page on the for
    ... My computer is client and other is server. ... I want to display all recevied values for parameters ... > I'm saying this because dynamically creating a few thousand controls might ... >> row data format will be same. ...
    (microsoft.public.vsnet.general)