Convert number to text

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

Guest

I need a simple method of linking a number field in a query to a text field
from a table (that I can't change). I know there is a Val function to
convert text to a number. Is there an equivalent function the other way -
number to text?
 
I need a simple method of linking a number field in a query to a text field
from a table (that I can't change). I know there is a Val function to
convert text to a number. Is there an equivalent function the other way -
number to text?
Click to expand...

Format(fieldname, "formatstring") probably; or CStr(fieldname) if your
text field is in the standard format for numbers defined in your
database properties.

It's not quite clear what is in your text field. If it's "Two hundred
and thirty-three dollars and forty-two cents" it'll be a lot harder
than if it's "$233.42".

John W. Vinson[MVP]
 
Back
Top