I am fairly New to access and have a subform within a form for users to enter information. The main form has a combobox where a selection is made and the subform displays all the records that correspond to the selection for the users to edit. There is underlying VB code with a select statement from a table that was used to do this.
There is a text box in the form whose control source is a memo field in the table. I am noticing that when data is displayed on the form (pulling from the table), everytime the memo fiield has more than 250 something characters, access fails to display the other fields in the form.
Oddly enough, the memo field itself displays in its entirety, the other text and numeric fields in the form are not displaying.
If i reduce the number of characters of the memo field to less than 250, the data does display. However i cannot do this in reality just to make the form work.
This is only an issue in Access 2003 and not 2007.
Is there any known fix for the issue? Help please! My users have Access 2003 only, so converting everyone to 2007 is not an option.
Thanks.