Text box won't accept format

J

JimS

I created a text box (tbPODollarValue) on an existing form. Its control
source is "=cbPONbr.column(3)" where cbPONbr is a control on the same form
sitting rightnext to my new text box (tbPODollarValue). I've set the format
on tbPODOllarValue to "Currency", and its Decimal Places to 2.

cbPONbr gets the right values. Its query is:
SELECT tblPO.ID, tblPO.PONbr, tblPO.ProjectID, tblPO.PODollarAmt,
ismember([GroupCode],moduleid()) AS Expr1
FROM tblPO
WHERE (((ismember([GroupCode],moduleid()))<>0))
ORDER BY tblPO.PONbr DESC;

tbPODollarValue displays the right value, but doesn't format it correctly.
It's formatted "general" instead of "currency".

Why?
 

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

Excel does not accept text format! 0
Currenct issue with a text box 1
Can't Format Text Box 2
Format list box contents 3
text box format 11
Text Box in Forms 6
Sum Calculated Field Question 1
Combo Box Format 2

Top