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.

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.
--
Dave Hargis, Microsoft Access MVP


"Linda in Iowa" wrote:

> 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.
>
>
>

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" <Klatuu@discussions.microsoft.com> wrote in message
news:138F2AF5-3076-4A49-808D-7D5F02A147D9@microsoft.com...
> 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.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "Linda in Iowa" wrote:
>
>> 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.
>>
>>
>>

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


"Linda in Iowa" wrote:

> 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" <Klatuu@discussions.microsoft.com> wrote in message
> news:138F2AF5-3076-4A49-808D-7D5F02A147D9@microsoft.com...
> > 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.
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "Linda in Iowa" wrote:
> >
> >> 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.
> >>
> >>
> >>
>
>
>

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

"Klatuu" <Klatuu@discussions.microsoft.com> wrote in message
news:28AFD887-AC45-46EE-8306-3077A8DE0FB5@microsoft.com...
> 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
>
>
> "Linda in Iowa" wrote:
>
>> 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" <Klatuu@discussions.microsoft.com> wrote in message
>> news:138F2AF5-3076-4A49-808D-7D5F02A147D9@microsoft.com...
>> > 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.
>> > --
>> > Dave Hargis, Microsoft Access MVP
>> >
>> >
>> > "Linda in Iowa" wrote:
>> >
>> >> 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.
>> >>
>> >>
>> >>
>>
>>
>>