How to get comma-separated number with a concatenation

[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

 

[Phobos]

=Format([Text409],"#,##0") & " Total Units"

P

 

[DOYLE60]

Thanks.

Matt