Datasheet view - fields not selecting

[journeyman]

Hi all,

I have come upon an issue I've never seen before, and a google search reveals nothing.



I have a standard datasheet with several fields. Some fields can be selected and the data contained within highlighted.

However, some fields simply go empty when clicking into them. Click back out and they resume the display of the data. Additionally the field search feature (dropdown) is completely blank. It's like the data is there, but not if you look at it.

Kinda like the Uncertainty Principle...except that I don't know how fast it's going either...:OP

Stupid jokes aside, I have tried recompiling, compact/repair. Strangely I can manually retype into the field, and the data seems to be fixed.

I have thousands of records in these tables. What would be the cause and how can I resolve without having to retype everything?

Cheers

[June7]

By datasheet do you mean a table or a form set for datasheet? Tables are local Access tables or linked?

[Micron]

Check your Client settings in File>Options. It might be that you've set "Behavior Entering Field" to "End of field", and you have multiple lines in the field. IIRC, that setting will scroll everything else up when you click on it so that you can append data, and you might not see what comes before as a result. That can depend on the height of the datasheet row. Also, open the table in datasheet view and increase the row height by 2 or 3 hundred percent and see if there are multiple lines in those fields.

[journeyman]

Check your Client settings in File>Options. It might be that you've set "Behavior Entering Field" to "End of field", and you have multiple lines in the field. IIRC, that setting will scroll everything else up when you click on it so that you can append data, and you might not see what comes before as a result. That can depend on the width of the datasheet column. Also, open the table in datasheet view and increase the row height by 2 or 3 hundred percent and see if there are multiple lines in those fields.

Thanks all, and Micron. It turns out that this was the issue. that I couldn't see the additional lines in the data. I probably should have known better. in any case the issue was resolved.

cheers

[Micron]

Glad to help!