I forgot about that...
And you said it only gives you the last two digests of the year? What version of access you do have, 98? In 2000, it seems to be the same! I am gunna use this!
Thank you Whammy, it must of been all the scripts i have downlaoded and learned from that made me think if i wanted the date i need to add it in the code.
I still wonder, it might mess me up again for the date. Because I inserted Now() into the db, now i am doing the same thing but having the date just be ready to be put in the db by default.
If I don't know why it happened int he first place, there is no way of me stoping it from happening again.
It has happened with a number of db's that hav had the date added to them.
I would love to know of anyone else that had this problem, and I would love to know if it's just me. Cause if it is, it could of been that I had my setting as dd/mm/yyyy at one point after a format, even though, i don't remember changing anything like that.
That is why i came up with the code:
StrWhen = Month(Now()) & "/" & Day(Now()) & "/" & Year(Now()) & " " & FormatDateTime(Now(), vbLongTime)
Well see what happens in the future