Filed size problem

[Haynesey]

Hi,

I am designing a training database and have a training table linked to a lookup course list table which includes a memo field containing the objectives of each course.

On the main training form, there is a drop down menu to select the course from the course list. Once the course is selected, all the details from the course list table are shown on the form. However, only so many characters are shown in the objectives field. Not all of the text is visible.

Any ideas?

Thanks in advance
Lee

 

[ColinEssex]

As a very rough guess, it sounds like you are trying to read a memo field in a text field. The memo field holds hundreds of characters and the text field is limited to 250.

Any good?

Col

 

[Haynesey]

Hi,

Thanks, but I thought that at first, it doesn't seem to be that, any other ideas?

Can i send you the database please?