How to get comma-separated number with a concatenation

  • Thread starter Thread starter DOYLE60
  • Start date Start date
D

DOYLE60

I have a numeric textbox on a form called Text409. I have another box,
referring to that field with this in the Control Source:

=[Text409] & " Total Units"

Since there never will be only one unit, I don't have to correct for the
plural. But the problem is that it returns numbers without the separating
comma. I get:

10786 Total Units

But what I really want is:

10, 786 Total Units.

What is the right format to get it to return what I want?

Thanks,

Matt
 
Back
Top