February 2nd, 2004, 07:05 AM
Change to UpperCase in Access
I'm not 100% sure how it's done... i've tried this:
Basically, if someone typed postcode in LowCase i want access automatically to change it to UpperCase...
I'd prefer if that was done using coding... if statement would be great. That's what i was trying to do..
On exit procedure(when you live the field)
Dim LowerCase, UpperCase
Dim Postcode As String
If Postcode.Text = LowerCase Then
UpperCase = UCase(Postcode)
February 2nd, 2004, 09:27 AM
oh, come on this forum sucks...no1 can help me with a simple task...
February 2nd, 2004, 10:10 AM
Well for starters you have to remember that all of us have jobs of our own and don't have time to sit here all day waiting in anticipation of answering you question. Most of us are patient enough to know the occasionally it takes more the 2 hours to get a response.
With that said, I wouldn't even run through an if statement
WhateverField = Ucase(postcode)
the input mask to Your field
February 3rd, 2004, 11:04 AM
I'm sorry mate, but option 1 doesn't work, and i don't know what you mean by option 2,
for option1 i tried:
February 3rd, 2004, 11:57 AM
option 2 is an input mask. The input mask is set at the properties level of the field in your table, or on the textbox on your form The says if you enter a postal code as:
Change it to
OPtion one is used where you have take the value stored in your field, put it in a variable. then you uppercase the text in your variable and put it where you want it.
I would use the input mask myself (cleaner)
February 5th, 2004, 06:08 AM
Thanks a lot mate... i finally did it...
but u know what? I used the input mask and i only put ">" into format field and that did the trick. However, it wasn't working when i was putting ">CCC-CCC" it would change the postcode l7 4qq into "CCC-CCCL7 4QQ" and for ">CCC" i would get "CCCL7 4QQ"... strange..
Is it supposed to work that way, anyways, thanks for your time mate,
February 5th, 2004, 09:38 AM
The C is suppose controls the kind of data entry that is allows, At least it doesn for me in the USA, Maybe there is differences between the version sold here and in the UK, I didn't think that was so.
At least it is working and that is what counts.