I have put a date field on and have discovered that the only way to make the box default to 'NOW' is by putting a check box on the field - is there any way to make this happen without a check box - or can I hide the check box in some way as I think it looks a bit less professional - and some of the users are 'creative' to say the least!?

What application are you working in? and

What is the checkbox for again

____________________________
Eggheads unite! You have nothing to lose but your yolks.

Oh - hello again Bean - thx for the 'Exit' code btw.

This is a user form that populates my Excel spreadsheet.

The properties for the field require a default value when you place it on the form UNLESS you select 'true' for the checkbox property - in which case the system date appears as a default when the box is checked BUT with the checkbox showing to the left of the date - I would really like the system date as default but not have the checkbox showing.

I'm very new to this so I really appreciate your kindness and patience.

Oh...OK...

turn your checkbox property off then try this...

Sub Change_Date()     Userform1.DTPicker1.Value = Now() End Sub

____________________________
Eggheads unite! You have nothing to lose but your yolks.

Thx once more Bean    

I'll give it a try - it's a bit of a bugger trying to move stuff from my machine with VB Enterprise to 'bog standard machines' with only VBA - so much works fine here but not on the user's.

Btw - I too love online games - been playing Ultima Online since '97 - not too good at the shoot 'em ups - too old!

you're never too old...

____________________________
Eggheads unite! You have nothing to lose but your yolks.