convert a date to a string

[dead7]

I have a date field that need to be converted to a string in a public function. Does anyone know how to do that,
[DATE]. I am getting a data type mismatch. or can I reference a field from a form in a public function like
dim forms!formname!fieldname as string, probably not?

 

[PHV]

Why not simply use the Format function ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[snyperx3]

Will CStr(Date) work?

-Pete

 

[stix4t2]

Dead7,

Maybe you could give us a reason behind your request, or more detail. You can use the activecontrol property to access the current control from a public function when you call that function.



Stix 42
Long Live Rock and Roll
Pop is for drinking