By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,663 Members | 2,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,663 IT Pros & Developers. It's quick & easy.

1st character of field Uppercased only with input mask?

P: n/a
When I want the first character of a field to be Uppercased, I need to
make an input mask, like >L< followed by ??????? for example. But this
mask creates ____ in an unfilled field, which I don't like. How to get
the fist character uppercased without an input mask or without ____
(underscores).

When I click with the mouse on an empty field, it won't go to the far
left side, cause of the input mask. How to avoid it?

Bart

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
AA Arens wrote:
When I want the first character of a field to be Uppercased, I need to
make an input mask, like >L< followed by ??????? for example. But this
mask creates ____ in an unfilled field, which I don't like. How to get
the fist character uppercased without an input mask or without ____
(underscores).

When I click with the mouse on an empty field, it won't go to the far
left side, cause of the input mask. How to avoid it?

Bart


From the help file (note last paragraph)...

The InputMask property can contain up to three sections separated by
semicolons (;).

First Section Specifies the input mask itself; for example, !(999) 999-9999.
For a list of characters you can use to define the input mask, see the
following table.

Second Section Specifies whether Microsoft Access stores the literal display
characters in the table when you enter data. If you use 0 for this section,
all literal display characters (for example, the parentheses in a phone
number input mask) are stored with the value; if you enter 1 or leave this
section blank, only characters typed into the control are stored.

Third Section Specifies the character that Microsoft Access displays for the
space where you should type a character in the input mask. For this section,
you can use any character; to display an empty string, use a space enclosed
in quotation marks (" ").

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
Try this:

Private Sub yourfield_AfterUpdate()
Me!yourfield= UCase$(Left$(Me!yourfield, 1))
End Sub
"Rick Brandt" <ri*********@hotmail.com> escreveu na mensagem
news:Mj****************@newssvr12.news.prodigy.com ...
AA Arens wrote:
When I want the first character of a field to be Uppercased, I need to
make an input mask, like >L< followed by ??????? for example. But this
mask creates ____ in an unfilled field, which I don't like. How to get
the fist character uppercased without an input mask or without ____
(underscores).

When I click with the mouse on an empty field, it won't go to the far
left side, cause of the input mask. How to avoid it?

Bart


From the help file (note last paragraph)...

The InputMask property can contain up to three sections separated by
semicolons (;).

First Section Specifies the input mask itself; for example, !(999)
999-9999.
For a list of characters you can use to define the input mask, see the
following table.

Second Section Specifies whether Microsoft Access stores the literal
display
characters in the table when you enter data. If you use 0 for this
section,
all literal display characters (for example, the parentheses in a phone
number input mask) are stored with the value; if you enter 1 or leave this
section blank, only characters typed into the control are stored.

Third Section Specifies the character that Microsoft Access displays for
the
space where you should type a character in the input mask. For this
section,
you can use any character; to display an empty string, use a space
enclosed
in quotation marks (" ").

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #3

P: n/a
I became familiair with Input masks, however

Private Sub yourfield_AfterUpdate()
Me!yourfield= UCase$(Left$(Me!yourfield, 1))
End Sub

caused the cursor to be moved to the left / last character.

But, it caused also that only 1 character is filled after update:
Like:
keyboard > K
and not
keyboard > Keyboard

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.