Help Please - Changing Case on Import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am running A2002 and importing into a table from Excel - The output file
is in upper case and I would like to change some fields to title case on
import.
The import into table ADRtbl which contains address Name & Address fields is
initiated from a contol on a form called Processfrm

Any help would be much appreciated

Thank you
 
You can use the StrConv to convert the string to any format

e.g: FieldName = ofer

StrConv([FieldName],1)
will return - OFER

StrConv([FieldName],2)
will return - ofer

StrConv([FieldName],3)
will return - Ofer
 
Thanks Ofer

Still having problem, the form I am using to process,that holds the button,
is unbound so I need to reference the code back to the table ADRtbl and the
specific field ord2

My attempts

Private Sub Command5_Click()
StrConv([ADRtbl.ord2],3)
End Sub

Or from Access Web

Me.[ADRtbl.ord2] = LCase(Me!ADRtbl.ord2)

I have tried various combinations using ! or .

But no joy as yet

Any ideas - many thanks again for the support

Best regards

Ofer Cohen said:
You can use the StrConv to convert the string to any format

e.g: FieldName = ofer

StrConv([FieldName],1)
will return - OFER

StrConv([FieldName],2)
will return - ofer

StrConv([FieldName],3)
will return - Ofer

--
Good Luck
BS"D


Paul said:
Hi

I am running A2002 and importing into a table from Excel - The output file
is in upper case and I would like to change some fields to title case on
import.
The import into table ADRtbl which contains address Name & Address fields is
initiated from a contol on a form called Processfrm

Any help would be much appreciated

Thank you
Click to expand...
Click to expand...
 
Back
Top