format text

[Linda in Iowa]

Is it possible to format text that is imported from a spreadsheet? Data is
entered to an online registration service. I download it in the form of a
spreadsheet. Data is received in every possible manner. I would like some
fields to have the first letter capitalized and the remaining lowercase. I
am asking this because I am updating a database and this is the format they
have used for manual entry.

 

[Klatuu]

Using the TransferSpreadsheet or TransferText methods, you have no ability to
affect formatting of the data being imported.
An alternative would be to link to the spreadsheet and use an append query
to move the data into your tables. You can do the formatting in the append
query.

 

[Linda in Iowa]

I have append and update queries. I assume I need to do this in the property
of each field in the query. I know I can do upper case or lower case. I
have not been able to find a way to do Title case.

 

[Klatuu]

You can get Proper Case by using the StrConv function. The paramenter is
vbProperCase, but in queries you have to use the actual value of the constant
which is 3, so it would be:

ProperField: StrConv([MyField], 3)

 

[Linda in Iowa]

Thanks. Got it to work on my append query. Now to make the necessary
changes to the update query.

You can get Proper Case by using the StrConv function. The paramenter is
vbProperCase, but in queries you have to use the actual value of the
constant
which is 3, so it would be:

ProperField: StrConv([MyField], 3)

--
Dave Hargis, Microsoft Access MVP

I have append and update queries. I assume I need to do this in the
property
of each field in the query. I know I can do upper case or lower case. I
have not been able to find a way to do Title case.