Add max value textbox

[wilco]

Hi there,

Im new with VBA. At the moment im working on a form where you have to fill in the current date. It works fine.

When i enter the date 32-04-2011 the form gives an error beacause a Month doesnt have 32 days. Is there a way how i can put a maximum (31 days) value to a textbox?

greetings,

 

[northwolves]

Use a dtpicker control instead of textbox or use ISADTE() function to tell if an expression is a date or not.