Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Convert Numbers to Text

Convert Numbers to Text

Convert Numbers to Text

Can someone please help me? I need to convert a numbers column in an access table to a text format


RE: Convert Numbers to Text

Your question is a bit spartan. I assume you have a need to only format the value and not change the data type of the field.
You can use CStr([YourNumericField]) or in a query just add a zero-length string [YourNumericField] & "".

Hook'D on Access
MS Access MVP

RE: Convert Numbers to Text

TJVFree may want to do this (who knows…?)

1 convert to “one”
10 convert to “ten”
123 convert to “one hundred twenty three”

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

RE: Convert Numbers to Text

Do you want to change the data IN THE ACCESS DATA COLUMN to text in the Access Table, or do you want to convert the numeric values from you Access data column to text in a query?

RE: Convert Numbers to Text

Good call Andy. This is one of those questions that should be accompanied by some context and examples.

Hook'D on Access
MS Access MVP

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close