define properties and Inputmask txtfield in form
Hi Specialists,
I'm dutch-speaking so forgive me my english a little bit.... Thanks
I've created a form named "frmNieuw" withe different kind of fields. 3 of them are a txtfield named "Start" - "Einde" - "Einde volgend jaar"
Ik you look in the sheet you can see what the form soes when you click the blue button "Nieuw lijn..."
A new line is created, the form starts up and after cklicking de "Toevoegen" button all the inputs go to there cells.
So far no problem...
However the " inputs "Start" - "Einde" - "Einde volgend jaar" goes to the colum M - N - O and Excel changes the properties for example 15-01-16 becomes 01-15-16 even when the cell propertie is set to dd-mm-jj
In the comum M it's correct, but in the colums N an O it goes sometimes wrong, depend on the date.
My question is : Is it possible to set a date propertie in a field of my form? And is it also possible to set a inputmask (like in access) for these fields? for example : --/--/--
In attachement a copy of the excel file
Thanks in front for your sollutions.
Best regards
Pascal
|