Recent content by MizLyn74

We went back and tried again, the data isn't there at all - basically the field is behaving like a Text field instead of a Memo field....we have checked everything we know and it just isn't cooperating....I have seen several posts and commentary about Memo fields being truncated in queries or...

Front and back end are both Access 2007. They are both set to memo field and default to 2gb of data.

The front end is Access....but I do have to correct my original post -although the fields allowed input of more characters in the test version of the database - apparently it does cut them off at 255 when you exit the field...I just re-tested.

I have a database that has two memo fields, when tested the memo field did not limit characters entered but when the database was launched on the company intranet and an employee tried to use it, their entry into these fields was limited....why would that be? I have entered up to four thousand...

It's a Safety Program so the reporting would be done by an employee and the 'persons involved' could be anybody, additional employees, customers....or there could be none at all! We wanted the form to be as simple (and as small) as possible but give the opportunity to add more entries if needed....

I am working on a database (in Access 2007) that people will use to submit 'Event Reports'. There are two forms and on one of them there is a place to enter names and contact information for people involved....what I want is to have one set of fields visible but give them the option to add...