Formulas

[June7]

Format property of textbox. If Access recognizes the calculated field as a number type, the dropdown list should present options, including Currency.

[joh344]

Text box is blank. The pull down menu is blank. I've typed in currency, but it doesn't do anything.

[casinc815]

Also remember multiplication, then addition, then subtraction, then division. You will need parens to support
those algebraic sequence and the sequence of events in making the calculations. Math calculations are generally in that order, not reading the equation left to right to do the math. The moderator used parens in his last reply. They were applied correct. Other responses above, do not use parens correctly. Good luck!

[June7]

The textbox is bound to field? Then Access does not recognize the value as number. Options are to use a conversion function (CInt, CLng, CDbl) on the query field so that it will be recognized as a number or to use the Format function.

If you want to provide db for analysis, follow instructions at bottom of my post.

@casinc815 - is your post in the correct thread? Not sure how your comments apply.