The value you entered isn't valid for this field

From CCMDB Wiki
Jump to navigation Jump to search


If a field is entered in a format that doesn't follow what MS Access expects, there is an error:

The value you entered isn't valid for this field.
For example, you may have entered text in a numeric field or a number that is larger than the FieldSize setting permits. 

See also DatePicker generated date looks different than usual until saved.

For the purpose of CCMDB.accdb this usually happens when a date is entered manually in a DatePicker field and all the punctuation and spacing is not as it should be.

DatePicker in Px Date field

The Px Date field in Patient Viewer Tab CCI Pick now needs to have a time entered in some cases for Change to collect TISS data in CCI Picklist. Usually only dates (not times) need to be entered into this field, so it was set up with as a datepicker field. Datepicker fields still can have times manually entered into them, but they are really picky about how the times are spelled out, ie you need to actually put the space between the date and the time, and the ":" between the hours and minutes. When the time is not spelled out right, the above error shows up.

  • I don't know enough about how that field is generally filled by collectors to know what is less hassle: have the convenience of the datepicker or the convenience of easy typing in of a date. Only CC uses the times, and even they only use it for some TISS entries. However, if it turned out that everyone uses the *, + and - buttons and no one uses the date picker, I could change the field so that typed date entry is less flaky. Do collectors have thoughts about this? Ttenbergen 11:03, 2020 December 23 (CST)
    • No additional info from collectors in some time, so assume fixed. Ttenbergen 13:13, 2021 February 12 (CST)

Related articles

Related articles: