Want to get date as dd-mm-yyyy format

[cyberdyne]

I am building a small app in vb and backend as access 2000.
Where I am displaying date in a textbox. Date format i want to save is dd-mm-yyyy . is it possible with access ?

How do i do it ? From:
Apoorva Gala
You can mail me at apoo1972@rediffmail.com

 

[thornmastr]

I gather you want to save a date as a text string?

Yourstring = format(yourDate,”dd-mm-yyyy”).
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[athos07]

select your table.

in the design mode. put the format dd-mm-yyyy

you can find this in the general tab