display currency

[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

 

[Guest]

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.

 

[John Nurick]

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"

 

[Guest]

Thanks much John.

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"