Hello Xavier.

I have a textbox with a control source to a datetime field.

If the DATETIME() field is updateable, the easiest thing to do is to create a class that handles this for you. Check out

Thread ID: 965996
Message ID: 966164
Title: Re: Display a date from a datetime?

For my solution.