Recent content by swotr

I still see the issue in the database that you updated where if i select Business unit BU1 and Department DG1, and go to the second activity (where the memo field (Annual activity) is more than 250 or so characters), all the remaining fields on the form are empty. I feel like i am missing...

Hello? Anybody been able to view the database to see the issue i was describing?

Here is the cleansed database. In the Form selections please use BU1 in the Business Unit selection box and DG1 in the Department/Group selection box to see what i am describing. The password to the VB code is annualbusinessplan Thanks!

Thanks for the suggestions. I have tried the above 1. Deleting the text box and reinserting it (attached to the memo field in the table). However i dont understand what you mean by memo box. 2. Recreating the form from scratch. Neither seems to work. However i did notice that the subform on...

SP2. Should i install a more recent service pack?

I did some more investigation and found that every time the memo field in the table exceeded (250 and something) characters, that is when access 2003 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...

The other data fields are on the subform also. One thing I discovered is that when i use Microsoft office 2007 (on my home computer, this issue does not exist. It exists only in Office 2003. Unfortunately all the users only have office 2003. Any suggestions?

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...