year format

[giridharv77]

i am using VB with oracle database, suppose a record in oracle is 21-jan-99, this record becoming 21-jan-2099 while i am displaying in form since i want the format as MMM-DD-YYYY, HH:MI:SS, so please help me how can i get rid off this problem toget my output as 21-jan-1999...pl help me.asap

[Serge]

You can format the record like this:

Text1.Text = Format(rs("FieldName"), "MMM-DD-YYYY, HH:MI:SS")

Where rs is a recordset object.

------------------

Serge

Senior Programmer Analyst
sdymkov@microage.com
Access8484@aol.com
ICQ#: 51055819 (http://www.icq.com/51055819)