B
BSMan
I've never seen this before and don't have any idea how to fix it.
Hopefully, someone can help. I have a form in Access 2000 (SQL Server back
end) which has two sub forms. The data source for the main form is a query
which uses one SQL table selected for a date value on the main form's footer.
The main form displays a combo box based on an ID value in the main table, a
date, and a memo field. These problems happen:
1. When you go to a record with data in the memo field, the entire field is
highlighted....except the text cannot be seen because the highlighting and
the text are both black (or there is no text, see item 2).
2. If you click somewhere where the text should be, the highlight of the
entire text disappears, but no text is displayed.
3. If you then move to the previous record, the text for the starting
record is displayed. However, if you print the report, or close the form and
reopen the form, the text is with the correct record.
Help! The only thing about this that triggers a flag to me is the fact that
this is a memo field, and I know that a memo field actually contains a
pointer to the real location of the text.
Bob
Hopefully, someone can help. I have a form in Access 2000 (SQL Server back
end) which has two sub forms. The data source for the main form is a query
which uses one SQL table selected for a date value on the main form's footer.
The main form displays a combo box based on an ID value in the main table, a
date, and a memo field. These problems happen:
1. When you go to a record with data in the memo field, the entire field is
highlighted....except the text cannot be seen because the highlighting and
the text are both black (or there is no text, see item 2).
2. If you click somewhere where the text should be, the highlight of the
entire text disappears, but no text is displayed.
3. If you then move to the previous record, the text for the starting
record is displayed. However, if you print the report, or close the form and
reopen the form, the text is with the correct record.
Help! The only thing about this that triggers a flag to me is the fact that
this is a memo field, and I know that a memo field actually contains a
pointer to the real location of the text.
Bob