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

Forcing Uppercase

P: n/a
I know that to format text to all caps I can use the capital period
symbol, but this seems only to effect how the data looks. In a two
letter state field, a mail merge will output lowercase letters even
with the uppercase formatting applied. What am I missing?
Thanks, Jon
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Mon, 27 Oct 2003 19:51:40 -0500, Jon Bergstrom <j.*********@valley.net> wrote:
I know that to format text to all caps I can use the capital period
symbol, but this seems only to effect how the data looks. In a two
letter state field, a mail merge will output lowercase letters even
with the uppercase formatting applied. What am I missing?
Thanks, Jon


As you have discovered formatting has no affect on the underlying data, it is for display only.

Use the StrConv function in the AfterUpdate event of your control to physically convert the entered text to uppercase.

Sub MyControl_AfterUpdate()

Me.MyControl = StrConv(Me.MyControl , vbUpperCase)

End Sub
Wayne Gillespie
Gosford NSW Australia
Nov 12 '05 #2

P: n/a
Thank You!
I did a bunch of work in Access 97, but it seems I have forgot all the
stuff I thought I knew....
Jon

On Tue, 28 Oct 2003 01:39:57 GMT, Wayne Gillespie
<be*****@NObestfitsoftwareSPAM.com.au> wrote:
On Mon, 27 Oct 2003 19:51:40 -0500, Jon Bergstrom <j.*********@valley.net> wrote:
I know that to format text to all caps I can use the capital period
symbol, but this seems only to effect how the data looks. In a two
letter state field, a mail merge will output lowercase letters even
with the uppercase formatting applied. What am I missing?
Thanks, Jon


As you have discovered formatting has no affect on the underlying data, it is for display only.

Use the StrConv function in the AfterUpdate event of your control to physically convert the entered text to uppercase.

Sub MyControl_AfterUpdate()

Me.MyControl = StrConv(Me.MyControl , vbUpperCase)

End Sub
Wayne Gillespie
Gosford NSW Australia


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.