Hello Friends!
I have some fields for user to enter dates. There's two types of fields where one filed's format is mm/yyyy and another field's format is mm/dd/yyyy. The goal here is to ensure user is aware of the date format being used. (mm/yyyy vs mm/dd/yyyy)
Is there an efficient way to show user the format (i.e "mm/yyyy" or "mm/dd/yyyy") when they click on the field to enter a date?
1) I have thought about defaulting the field value to "mm/dd/yyyy" but this is causing some problems as we use a lot of "IsNull()" in our codes. Maybe we can use IsDate() instead?
2) I tried adding a label nearby the field indicating the format but this is making the form messy.
3) Adding a date picker doesn't seem working well as it takes sometime to select a desired year.
I feel like there's an built-in tool to achieve this. I am really new to MS Access to any help on this is greatly appreciated.
Happy holidays!
Allan
I have some fields for user to enter dates. There's two types of fields where one filed's format is mm/yyyy and another field's format is mm/dd/yyyy. The goal here is to ensure user is aware of the date format being used. (mm/yyyy vs mm/dd/yyyy)
Is there an efficient way to show user the format (i.e "mm/yyyy" or "mm/dd/yyyy") when they click on the field to enter a date?
1) I have thought about defaulting the field value to "mm/dd/yyyy" but this is causing some problems as we use a lot of "IsNull()" in our codes. Maybe we can use IsDate() instead?
2) I tried adding a label nearby the field indicating the format but this is making the form messy.
3) Adding a date picker doesn't seem working well as it takes sometime to select a desired year.
I feel like there's an built-in tool to achieve this. I am really new to MS Access to any help on this is greatly appreciated.
Happy holidays!
Allan