adding £ to non-databound textbox..

  • Thread starter Thread starter Craig Armitage
  • Start date Start date
C

Craig Armitage

I have a text box that has a sum() from a table. The table is set as
currency but the total in the textbox is just numeric. how do i format the
textbox to use the format...

£1.00
£199.00
£1,999.00

thanks
 
great thanks, did the trick

KARL DEWEY said:
Try this --
Format([Price],"£#.00")

Craig Armitage said:
I have a text box that has a sum() from a table. The table is set as
currency but the total in the textbox is just numeric. how do i format
the
textbox to use the format...

£1.00
£199.00
£1,999.00

thanks
 

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

Back
Top