How do I force a Mask to be Capital letters? (1 Viewer)

[thorsonb]

Is is possible to have Access convert . switch / replace characters in lower case into uper case?


Eg I have an input Mask for Zip Code (Netherlands styeZ)
the ZIp code over there is as follows

4 digits then 2 characters
eg. 1276 HG , 3873 JY , 8120 PL

I would like the database to automatically switch/convert lowercase text entered into Upper Case
eg. If i were to enter " 6123 kr " as i press enter/ go to the next field on the table to enter data the " kr " are turned into uppercase

How is this possible?

 

[DCrake]

Use the AfterUpdate event of the control as such

Me.ActiveControl = UCase(Me.ActiveControl)

David

 

[thorsonb]

Ok this has me stumped, I Googled it, and it all leads me to Visual Basic...

I'm literally lost, isn't there another way with a Macro perhaps?

 

[DCrake]

If you look at the properties of rthe textbox that records the post code, there is are properties for before and after update. If you select the one you need (depending on bound or unbound form) and click on the elipses button (3 dots) and select Code builder.

You will be presented with the following

Private Sub Postcode_BeforeUpdate(Cancel As Integer)


End Sub

Enter the following code between the lines

   Me.Postcode = UCase(Me.Postcode)

This assumes that the name of the control is called Postcode.

David

 

[thorsonb]

Thanks for your help but I found out how to do it, Did some more googleing.

My postcode field is to be like this " 1276 HG " but when I enter text in lower case is remains as " 1276 hg "

My input mask was

0000\ LL;0;_

I solved this by using the " > " symbol ( Causes all characters to be converted to uppercase)

My Input mast now is

>0000\ LL;0;_

and it converts all text to upper case

Thanks

 

[accessprogramer]

If you look at the properties of rthe textbox that records the post code, there is are properties for before and after update. If you select the one you need (depending on bound or unbound form) and click on the elipses button (3 dots) and select Code builder.

You will be presented with the following

Private Sub Postcode_BeforeUpdate(Cancel As Integer)


End Sub

Enter the following code between the lines

   Me.Postcode = UCase(Me.Postcode)

This assumes that the name of the control is called Postcode.

David

This is a newbe question, but I'm stuck! You explained the Postcode, but what is me? The table name?
Thanks!

 

[jdraw]

You have found a post that is 4+ years old.

Do you really not know what table name means?

Me refers to the current Form you are working with.
Me.Postcode is the Postcode control on the current form.

You really need some introductory tutorials.
Relational Database Principles

Access Fundamentals By Crystal

Input mask samples

If you have more questions, I suggest you try searching the site, and/or creating a new post.
Good luck

 

[nanscombe]

This is a newbe question, but I'm stuck! You explained the Postcode, but what is me? The table name?
Thanks!

No, "Me" is not the table name. In this case it is a shorthand way of referring to the current Form.

Instead of having to say Forms("nameOfForm").PostCode you can just say Me.PostCode.