HOW TO MAKE ALL INPUT CAPITAL

B

babs

WHAT DO i NEED TO ADD TO MAKE ALL INPUT INFO BE CAPITALIZED ON FORMS NO
MATTER HOW IT IS INPUT

THANKS,
BARB
 
6

'69 Camaro

Hi, Barb.
WHAT DO i NEED TO ADD TO MAKE ALL INPUT INFO BE CAPITALIZED
Click to expand...

Change the text box's Format Property to a greater than sign: > while the
form is in Design View. If this is needed on all forms in the database,
then change the column's Format Property in Table Design View.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
J

John W. Vinson

WHAT DO i NEED TO ADD TO MAKE ALL INPUT INFO BE CAPITALIZED ON FORMS NO
MATTER HOW IT IS INPUT

THANKS,
BARB
Click to expand...

Well, you don't need to do so on Usenet newsgroups. In fact it's hard to read
and is considered impolite. It looks like you're SHOUTING AT US.

You can set the Form's KeyPreview property to Yes, and put code in each
textbox's KeyPress event:

Private Sub controlname_KeyPress(KeyAscii As Integer)
KeyAscii = Asc(UCase(Chr(KeyAscii)))
End Sub

John W. Vinson [MVP]
 
B

babs

Sorry about the all caps in the posting. Wondering if it would just be
easier to add the > sign to the format in the table as noted above- Is there
an advantage to doing the way you suggested - I haven't heard of this one
before? Just curious.

Thanks so much and sorry again,
Barb
 
J

John W. Vinson

Sorry about the all caps in the posting. Wondering if it would just be
easier to add the > sign to the format in the table as noted above- Is there
an advantage to doing the way you suggested - I haven't heard of this one
before? Just curious.
Click to expand...

The > format, as Crystal suggested, will work - but there is a difference.
Using the > format the text is *stored* in the table exactly as typed - lower
case, upper case, mixed case; it's just *displayed* in caps. The KeyPress
code actually takes each letter as it is typed and permanently converts it to
upper case, so it's stored in all caps in the table.

John W. Vinson [MVP]
 
6

'69 Camaro

Hi, John.
The > format, as Crystal suggested, will work
Click to expand...

I think that I should probably point out that while you may see some
similarities between the two of us, our philosophies are diametrically
opposed. While she espouses striving for peace, I'd rather strive for world
domination. And I don't think she'd ever feel comfortable in my Dress
Blues. ;-)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
J

John W. Vinson

I think that I should probably point out that while you may see some
similarities between the two of us, our philosophies are diametrically
opposed.
Click to expand...

<OOPS>
<blush>

Sorry about the brainfade, Gunny! Two people I like... but as you say,
*different* people!

John W. Vinson [MVP]
 
6

'69 Camaro

J

John W. Vinson

I'm a twin, so I'm quite used to being called by someone else's name.
Crystal has a good sense of humor, too, so I'm sure she can appreciate the
irony of peace and guns being associated. :)
Click to expand...

Remembering the Berkeley bumpersticker from the minority opinion there in 1972
or so: PEACE THROUGH VICTORY!

John W. Vinson [MVP]
 
T

Tony Toews [MVP]

babs said:
WHAT DO i NEED TO ADD TO MAKE ALL INPUT INFO BE CAPITALIZED ON FORMS NO
MATTER HOW IT IS INPUT
Click to expand...

Why would you make something in all capitals? That's terribly hard to
read compared to mixed case.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top