Uppercase

[chris11590]

I place > character in the format box ,but as i enter data it doesnt not make the data in uppercase. can anyone tell me what i m doing wrong. i need for the first letter in uppercase, not the entire word. can anyone help me

 

[maxmangion]

you can use the strconv function.

 

[chris11590]

i get this function from the expression builder? can you tell me physically how to do this??

 

[maxmangion]

in the afterupdate event of your textbox put

Me.textboxname = strconv([FieldName], vbUpperCase)

 

[chris11590]

i havent created the form yet, creating table right now. i dont see events in the properties.

 

[maxmangion]

I wouldn't suggest you do the formatting at table level. You should make data entry from forms so it is there where you should convert your text to Uppercase.

 

[MSAccessRookie]

in the afterupdate event of your textbox put

Me.textboxname = strconv([FieldName], vbUpperCase)

I think he might want the vbProperCase instead of the vbUpperCase. What he said was:

i need for the first letter in uppercase, not the entire word.

vbProperCase converts the first letter to every word to uppercase. All other characters are left as lowercase. This option is similar to the InitCap function in Oracle.

 

[chris11590]

ok thank you both.

chrissy....(she lol)

 

[maxmangion]

you're right MSAccessRookie ... i read the first part of the question only

 

[MSAccessRookie]

you're right MSAccessRookie ... i read the first part of the question only

Thanks. I knew that your advice was good, but I also thought it would give all caps. That is the only reason the I replied. Chris should try what you suggested, with the modification to vbPropercase.

 

[maxmangion]

you're welcome chrissy.

Goodluck with your form(s) creation.

 

[MSAccessRookie]

ok thank you both.

chrissy....(she lol)

DOH!

P.S. Always glad to assist when I am able.

 

[chris11590]

when i enter the name , get an error message about macro not found to new etc....

 

[maxmangion]

where did you enter it ?

 

[chris11590]

after update in event tab

 

[maxmangion]

you should be clicking those three small dots next to the after update event and choose code builder, then place the code there.