display currency

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to display in a different currency

eg Rs. 1,00,000 (placement of ,)

Also, I would like to display date in dd/mm/yy format ...so, oct 20 -2004
would be
20/10/04

Thanks
 
I believe for your date issue what you need to do is select input mask under
the design view of the table for the field you want to change.
 
Hi ria,

For your first question, I suggest you go to www.google.com and search
for something like this (remember to use "OR" and not "or"):

vba rupees OR rs lakhs format OR display

For dates, set the format property of the field or textbox to
"dd/mm/yy"
 
Thanks much John.

John Nurick said:
Hi ria,

For your first question, I suggest you go to www.google.com and search
for something like this (remember to use "OR" and not "or"):

vba rupees OR rs lakhs format OR display

For dates, set the format property of the field or textbox to
"dd/mm/yy"
Click to expand...
 
Back
Top