>My friend is using VB and access together.
>
>The question is...
>he is storing a date filed in a table in a character format. He then exports the data to a text file and the date ends up changing to the windows regional setting..anyway to force the date to the current setting defined by the VB app
>
>TIA
use the format command. x = format(#2/2/00#,"MM/DD/YYYY")
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams