ms access - How to allow dayname in input string when inputting a date? -
in our continuous form in access want offer combobox show 7 days dayname part of dropdown. the combobox bound date field. can populate combobox in form load event show days in ddd dd/mm/yy format , existing dates happily shown on form so: however if try , pick dropdown error: the value entered isn't valid field. solutions involving unbound combobox won't work continuous form. it's kind of detail, dayname isn't absolutely necessary, , combo works fine without dayname. heavy duty data entry form optimising end user important , having daynames assist him/her. i recreated problem , solution came have combo box row source has 2 columns , hide first column using columnwidths , second column formatted date value. when pick in combo box, value unformulated date value gives no issue. populate combo so: dim integer = 0 6 dim item date item = dateadd("d", i, weekcommencingdate) cbotimedate.additem item & ";" ...