I was at a customers site today when i had an Access database presented to me<\/p>\n
“Where has all the data gone?!”\u00a0<\/p>\n
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.<\/p>\n
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.<\/p>\n
I went to the underlying table and it turns out this particular field had some custom formatting applied. All the other fields did not<\/p>\n
I removed the formatting and everything returned to normal<\/p>\n
It was sorted but i was still scratching my head as to WHY when someone said<\/p>\n
“It was fine until yesterday, then it all went funny this morning”<\/p>\n
So what changed? Turns out “someone” had installed Office 2003 SP3<\/p>\n
A bit of searching after the event turns out i’m not the only one who has run into this!<\/p>\n","protected":false},"excerpt":{"rendered":"
I was at a customers site today when i had an Access database presented to me “Where has all the data gone?!”\u00a0 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<\/p>\n