Format text field as number???

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

Guest

I have a text field that has numbers if applicable and text (N/D) if not. If
there are numbers they could range from 100 to 10,000. If the number is
1,000 or greater, I want to add the comma....but no comma if it is just a
3-digit number or text.

I got it to ALWAYS put a comma, but I can't figure out how to only put one
for a 4 or 5 digit number and nothing else. Can someone please tell me how
to accomplish this?

Thanks!
Susan
 
In the underlying query, you could use

IIF(Len(SomeField & "" )<4, SomeField,Format(Val(SomeField),"#,000"))

You can use similar logic in VBA code in the report section.

Also, you might be able to use conditional formatting to do this.
 
You must log in or register to reply here.

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

Format a number in a text field?? 2
Advice for field structure or query structure - not getting theresults I thought I should 2
Growing Textbox Formatting 1
Using TEXT and &TEXT - display numbers with commas, underline text 2
Output "Text","Text","Number" 1
format record count numbers 2
Check if text box has more than one entry seperated by a comma 2
Excel VBA - Force 4 commas into a text field on userform 7

Back
Top