How do I write a Strconv in Microsoft Access?

G

Guest

This subject was discused 3/18/2006 - What input mask will put capitals at
the beginning of any word. I'm importing data into microsoft, and all fields
are uppercase and I want to change the to proper case. One of my fields is
"status". I used the sample, strStreet1 = StrConver(strStreet1,
vbProperCase), nothing happen. What do I do once the conv is entered into
AfterUpdate Event?

Thanks,

Lenore
 
R

Rick Brandt

Lenore said:
This subject was discused 3/18/2006 - What input mask will put
capitals at the beginning of any word. I'm importing data into
microsoft, and all fields are uppercase and I want to change the to
proper case. One of my fields is "status". I used the sample,
strStreet1 = StrConver(strStreet1, vbProperCase), nothing happen.
What do I do once the conv is entered into AfterUpdate Event?

Thanks,

Lenore
Click to expand...

If you are importing data an InputMask is irrelevant. They only work for data
manually entered into a form. You can run an update query...

UPDATE TableName
SET FieldName = StrConv(FieldName, 3)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I make Access fields repeat previously entered data? 2
How do I copy a record from one table to another table in Access 1
New to access. I know what I want to do but not how 5
How do i use left function in Microsoft Access? 8
Access I need help with a data entry form in Microsoft Access 97 2
How do you decrypt a string in a Microsoft Access VB module that wasencrypted using EncryptDecrypt i 4
How do I rename a user-defined field in a Contacts folder? 5
How do I move a record from one table to another in Access 1

Top