Recent content by tooold

Thanks Paul, you're the best!

Hi guys, I have a problem like this: In a text box, [OrderDate], the default value is set to Date(). Now I wanna change the date without changing the default value and the new input value would be carried over to the next record until I say otherwise. Is there any way to do that??? Thanks

Hi, I've got this kind of error (see the pictured enclosed). Can you tell me me more what's wrong? (I've already checked all the possible spelling errors and put the code in the code window :confused: Thanks

Anyway, I still got an error message from Access even when i Put the code like this: Private Sub OrderDate_AfterUpdate() Me.OrderDate = Format(Me.OrderDate, "dd/mm/yyyy") End Sub What's wrong then?????

Thanks for the tip, but what I want to do is to make the format correct right when the user get to the field. I already made is like this: Private Sub OrderDate_Enter() Me.OderDate = Format(Me.OderDate, "dd/mm/yyyy") End Sub Questions: 1) Is this possible? 2) If yes, what's wrong with my...

Hi, I'm having a problem like this: I want users to put date in the field [orderdate] in the UK format (dd/mm/yyyy) no matter what their system date would be. I already put in the fomat property of the [orderdate] the desired format (dd/mm/yyyy). However, it somehow does not come out properly...