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
Click to expand...
Click to expand...
 
You must log in or register to reply here.

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

store a value of a text box that calculates data into a data sourc 2
label and currency textbox 5
Can you Change Certain Word Text Color in Concatenated Text Box? 3
Dynamically update userform label based on textbox 5
Databound textboxes 1
One TextBox Not Bound to Table 3
automatically updating textbox and adding it to tables 1
populate and update textbox 1

Back
Top