Convert a value to text??

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

Guest

I have an issue with an access query where if you report to file a specific
field is interpretted by excel as a mathematical value

example
the field holds code like 12D30 and when it is sent to excel excel displays
it as 1.2D+31.

Is there a function in Access (or alternaivly a vb module i can build) that
takes the value and forces it as a text value.

I have tried using the Cstr function but that doesn't work

Thanks in advance

Jai
 
It is 2002

I tried the CStr(NZ([FieldName])) and no joy ;(

Jai

Arvin Meyer said:
Which version of Excel? I had to force the field to get it to convert to a
number in Excel 2002.

You might try:

CStr(NZ([FieldName]))
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Jai_Friday said:
I have an issue with an access query where if you report to file a specific
field is interpretted by excel as a mathematical value

example
the field holds code like 12D30 and when it is sent to excel excel displays
it as 1.2D+31.

Is there a function in Access (or alternaivly a vb module i can build) that
takes the value and forces it as a text value.

I have tried using the Cstr function but that doesn't work

Thanks in advance

Jai
Click to expand...
Click to expand...
 

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

Similar Threads

Assigning values to text for calculation 0
ASCII Convert 11
Converting Text to Numeric Value 2
Converting a numeric field to text 1
Can I convert a date to text? 6
Convert imported text to date time 2
Append Query 2 4
Convert to text in a text box 1

Back
Top