I was at a customers site today when i had an Access database presented to me
“Where has all the data gone?!”
When attempting to select a value in a drop down (combo) the list appeared empty. If you selected an item the field value was updated correctly.
I found this a little wierd and it appeared to be affecting everyone and it appeared to only be occuring with instances with a particular field.
I went to the underlying table and it turns out this particular field had some custom formatting applied. All the other fields did not
I removed the formatting and everything returned to normal
It was sorted but i was still scratching my head as to WHY when someone said
“It was fine until yesterday, then it all went funny this morning”
So what changed? Turns out “someone” had installed Office 2003 SP3
A bit of searching after the event turns out i’m not the only one who has run into this!