Not sure why this one is so hard to figure out.
I originally wanted to have a default date value (7/1/2019) entered into a textbox field on a form. but no matter what I tried it would always enter the default date of 12/30/1899 or #Type!
not being able to figure this out I decided to try to figure out a much more complicated way of having a the default date value entered into the text box on focus, not surprising I couldn't figure that one out either.
For reference
this date is used as criteria in a query to find transactions between dates.
The text box is
Format: Short Date
Text Format: Plain Text
Show Date Picker: For dates
No input mask as I read that in order to get the date picker to show there can be no input mask.
and I need the date picker to still be available for use if the default date value is not used.
Thanks for any help