Memo Field will not show all data

[amanda27]

In my database I have a form that you go to enter project status for week ending. In that form I have a subform so that when you pick a project that it brings in the status entered for last week because so you can see what you put for last week before you put in this weeks. The status is set up as a memo field. For this one project it is cutting the data off. However when I go to print the report all the data is there. It's just when I am trying to review what was entered last week it doesn't show everything. It pulls up last weeks status with a query. Could the query be causing the cut in data. If so how do I fix that?
Thanks

[MMcCarthy]

In my database I have a form that you go to enter project status for week ending. In that form I have a subform so that when you pick a project that it brings in the status entered for last week because so you can see what you put for last week before you put in this weeks. The status is set up as a memo field. For this one project it is cutting the data off. However when I go to print the report all the data is there. It's just when I am trying to review what was entered last week it doesn't show everything. It pulls up last weeks status with a query. Could the query be causing the cut in data. If so how do I fix that?
Thanks

querying memo fields is a nightmare. It cuts off a 255 characters invariably. As a work around don't have the status field returned by the query. Instead put a dlookup in the textbox.

Mary

[amanda27]

I'm a little confused never working with DLookup before.
Here is what I have:
When you go in it auto populates this Friday's date, then you pull down a project from a drop down, then when you pick that project. The status, milestone, and next step (3 seperate memo fields) populate with last weeks project status and its pulling from a query based on the max date and the project you picked from the drop down.
Where would I put the DLookup? In the query, form, code? I would have to put it for all 3 unless I would make a MakeTableQuery and have it read from there. I am not sure what I should do.
Can you please help?

querying memo fields is a nightmare. It cuts off a 255 characters invariably. As a work around don't have the status field returned by the query. Instead put a dlookup in the textbox.

Mary

[MMcCarthy]

I'm a little confused never working with DLookup before.
Here is what I have:
When you go in it auto populates this Friday's date, then you pull down a project from a drop down, then when you pick that project. The status, milestone, and next step (3 seperate memo fields) populate with last weeks project status and its pulling from a query based on the max date and the project you picked from the drop down.
Where would I put the DLookup? In the query, form, code? I would have to put it for all 3 unless I would make a MakeTableQuery and have it read from there. I am not sure what I should do.
Can you please help?

Just stick a textbox (txtDesc) on the form and in the after update event of the combobox put the DLookup.

Me!txtDesc = DLookup( ...

[binner]

Try setting the field in the query to First instead of Group By.

[Sheilaweb17]

Try setting the field in the query to First instead of Group By.

Thanks for that - that's got my problem sorted .... cheers