display currency

R

ria

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
 
S

SD

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.
 
J

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"
 
R

ria

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...
 
Top