Report cutting off field 1

[Luongo1]

Hi, the reports that are created in my program based on a table/form are cutting off one of the fields when it exceeds a certain length - it looks like a number of characters as it's sometimes cut off mid-word. It continues to appear normally in the table records, however. Any idea on what could be causing this? It seems like it must be something fairly simple, but I couldn't figure it out in Access or find another thread regarding it here. Any thoughts would be appreciated. Thanks...

 

[dhookom]

Does your text seem to cut off at 255 characters? I expect your query syntax is the issue. It could also be a value in the Format property of the text box displaying your field.

If you can't figure this out, come back with the SQL view of your report's record source.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Luongo1]

Hi dhookom, thanks for your reply. Yes, it it cutting off after exactly 255 characters. Here is the SQL query I am using for the report (excuse the length). It is the Messages field that is being cut off, which is listed as a Memo data type in the type.

SELECT [Communication Log].Log, [Communication Log].Entered, [Communication Log].Time, [Communication Log].From, [Communication Log].Messages, [Communication Log].Shift, [Communication Log].Supervisor
FROM [Communication Log]
WHERE [Communication Log].Entered Between Forms![Generate Report]!BeginDate And Forms![Generate Report]!EndDate And IIf(Forms![Generate Report]!chkBox1=True,[Communication Log].Shift='1',[Communication Log].Shift=Null) ORDER BY Log ASC

UNION

SELECT [Communication Log].Log, [Communication Log].Entered, [Communication Log].Time, [Communication Log].From, [Communication Log].Messages, [Communication Log].Shift, [Communication Log].Supervisor
FROM [Communication Log]
WHERE [Communication Log].Entered Between Forms![Generate Report]!BeginDate And Forms![Generate Report]!EndDate And IIf(Forms![Generate Report]!chkBox2=True,[Communication Log].Shift='2',[Communication Log].Shift=Null) ORDER BY Log ASC

UNION

SELECT [Communication Log].Log, [Communication Log].Entered, [Communication Log].Time, [Communication Log].From, [Communication Log].Messages, [Communication Log].Shift, [Communication Log].Supervisor
FROM [Communication Log]
WHERE [Communication Log].Entered Between Forms![Generate Report]!BeginDate And Forms![Generate Report]!EndDate And IIf(Forms![Generate Report]!chkBox3=True,[Communication Log].Shift='3',[Communication Log].Shift=Null) ORDER BY Log ASC

UNION SELECT [Communication Log].Log, [Communication Log].Entered, [Communication Log].Time, [Communication Log].From, [Communication Log].Messages, [Communication Log].Shift, [Communication Log].Supervisor
FROM [Communication Log]
WHERE [Communication Log].Entered Between Forms![Generate Report]!BeginDate And Forms![Generate Report]!EndDate And IIf(Forms![Generate Report]!chkBox4=True,[Communication Log].Shift='4',[Communication Log].Shift=Null)
ORDER BY Log;

 

[dhookom]

Your [blue]UNION[/blue] is the cause of the issue. By default, [blue]UNION[/blue] will attempt to group by and remove duplicates. If you replace all [blue]UNION[/blue] with [blue]UNION ALL[/blue], you may be able to view the entire contents of your memo field.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Luongo1]

Thanks a lot! Worked great!