Report problem

[cbearden]

I have a report based on a query. When I bring up my report, memComments, will not show up on the report...instead it shows a tiny square box.

Any help is appreciated.

Thanks!

 

[ejstefl]

What is the data type of the underlying field on the table? What type of control are you using on the report?

 

[cbearden]

the data type is memo
the type of control is a text box

 

[Rich]

is there any formatting applied to the memo field, is there any grouping applied to the query?

 

[cbearden]

memo field has:

Caption : Comments
Default Value : =Null

In the query, the Total row has "Group By" in all except for one...which is Expression to count days.

 

[richary]

Is it maybe a control character, or an alphabet that Access cannot print??

 

[ejstefl]

I know that when I enter "..." into Access, it does some autoformating and converts it to a small square box (i assume this means a character Access cannot display).

If you view the field directly from the table, can you see the field as you expect?

 

[cbearden]

But would it do this for all records? even if it didn't contain a certian character.

Yes, I can view the Comments in my Table, Query, and Form.

 

[richary]

You could try temporarily setting the control source on the report to some dummy text. If it still prints the square box, its likely the control's formatting, otherwise its probably the query/table.

 

[cbearden]

I changed it refer to another field, and it showed it. but I changed it back to reference the memComments and its back to the square box.

What could this be? Could the "..." be causing this? Affecting every record?

 

[cbearden]

I deleted all the "..." in my comments.

Still a box shows.

 

[richary]

Seems unlikely that it should affect every record. Was the data originally entered using Access, or did it come from some other source? If you enter a new record using Access does it view OK

Only other thoughts (I must admit I am running out of them!) is to try viewing the report using another printer driver setup (if you have one).

 

[cbearden]

All comments have been entered via Access...none have been imported.

 

[ejstefl]

You could also try posting the DB here to see if we have the same problem...

 

[cbearden]

I think it has to do with my query. I need to split up some info into two queries. I have #'s that start with 121, 122, 123, 124.

121 and 124 needs to be together.
122 and 123 needs to be together.

I had this in the criteria field:

Like "121###"
Like "124###"
These were on seperate lines.
Once I put this in, it changed the comments to the box.

Any suggestions?
Thanks

 

[richary]

I'm not an SQL expert, sorry.
So that others can help, could you post the whole of the SQL queries?

 

[ejstefl]

Are the fields where you are putting that text fields, or numbers? Can you post the query?

 

[cbearden]

I think its actually the expression I have.


SELECT [Dealer Contact Info].intDealerNum, [Dealer Contact Info].txtDealer, [Dealer Contact Info].txtContact, [Warrenty Log].txtName, [Warrenty Log].dtmSent, Sum(Date()-[dtmSent]) AS [Total Days], [Warrenty Log].curGcost, [Warrenty Log].curSCcost, [Warrenty Log].curCLcost, [Warrenty Log].curOcost, [Warrenty Log].curMPPcost, [Warrenty Log].memComments
FROM [Dealer Contact Info] INNER JOIN [Warrenty Log] ON [Dealer Contact Info].intDealerNum = [Warrenty Log].intDealerNum
GROUP BY [Dealer Contact Info].intDealerNum, [Dealer Contact Info].txtDealer, [Dealer Contact Info].txtContact, [Warrenty Log].txtName, [Warrenty Log].dtmSent, [Warrenty Log].curGcost, [Warrenty Log].curSCcost, [Warrenty Log].curCLcost, [Warrenty Log].curOcost, [Warrenty Log].curMPPcost, [Warrenty Log].memComments, [Warrenty Log].chkAll
HAVING ((([Dealer Contact Info].intDealerNum) Like "121###") AND ((Sum(Date()-[dtmSent]))>45) AND (([Warrenty Log].chkAll)=False)) OR ((([Dealer Contact Info].intDealerNum) Like "124###") AND ((Sum(Date()-[dtmSent]))>45) AND (([Warrenty Log].chkAll)=False))
ORDER BY [Warrenty Log].dtmSent, Sum(Date()-[dtmSent]) DESC
WITH OWNERACCESS OPTION;

 

[Brianwarnock]

Access help states

Wildcard characters are meant to be used with fields that have the Text data type. You can sometimes use them successfully with other data types

Iwonder if this addresses your problem?

Brian

 

[richary]

Hmm. As I said, I'm not a SQL expert, but your grouping by memComments. Assuming this is a free text field, is that wise?