Converting a number field into a text field

G

Guest

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???
 
T

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
 
V

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)




Jackie said:
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???
 

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

Top