Converting a number field into a text field

[Jackie]

I link my databases to our AS400 server in another location. When the table I need from the AS400 has the fields I need I can not use them because they are in the wrong format. (IE Number when I need Text.) What is the propper function, command, macro to tell access to convert them over

When I attempt to open up the table and convert the field manually it states there is not enough memory. Can anyone help???

 

[R. Hicks]

Use the CStr() function ..

RD

 

[Tom Ellison]

Dear Jackie:

If you don't need to specify a format, that is, just be able to get
the values without worrying about how many decimal places are filled
with zeros on the right, then just CStr() function should be good.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[Van T. Dinh]

Not sure from what you posted but you cannot change the Field type of a
linked Table.

OTOH, Access is fairly generous with type-casting and quite often Access
will type-cast the values automatically. For example (from A2K Debug
window):

?"This is number " & 1
This is number 1

You can see that I ask Access to concatenate a String with a *numeric*
value. From the context of the expression, Access type-casts my numeric
value 1 to a String "1" and then concatenate the 2 Strings for me.

--
HTH
Van T. Dinh
MVP (Access)

I link my databases to our AS400 server in another location. When the

table I need from the AS400 has the fields I need I can not use them because
they are in the wrong format. (IE Number when I need Text.) What is the
propper function, command, macro to tell access to convert them over?

When I attempt to open up the table and convert the field manually it

states there is not enough memory. Can anyone help???