The problem I'm having is trying to get the coma to appear when it should (1,200) it does appear in the column. I have tried to format the values in the Combobox Row Source Select statement like this,
Expand|Select|Wrap|Line Numbers
- Format(tAmmo.GrossQty, "#,###") AS ["GrossQty"], Format([tAmmo].[TargetLevel], "#,###") AS ["TargetLevel"]
Everything works like it should until a textbox gets a blank instead of a zero. I've spent two days on this and now I need some help.
How do I force a zero when the column forces a blank, all this because I placed a numeric format in the select statement?