Report text box showing squares

[Guest]

Duane Hookom, the database I designed comes from your Survey database, it is
great. I have added a few things, here is the sql from the crosstab query.

PARAMETERS Forms!fmnuReportSelect!cboSrvID Long;
TRANSFORM Count(tblResponses.Rspns) AS CountOfRspns
SELECT tblQuestions.QstnID, tblQuestions.QstnLvl1, tblQuestions.QstnLvl2,
tblQuestions.QstnLvl3, tblQuestions.QstnText, tblResponses.Rspns,
tblQuestions.SrvID
FROM tblSrvRspns INNER JOIN (tblQuestions INNER JOIN tblResponses ON
tblQuestions.QstnID = tblResponses.QstnID) ON tblSrvRspns.RspnsID =
tblResponses.RspnsID
WHERE
(((tblSrvRspns.numFiscalYear)=[Forms]![fmnuReportSelect]![lstFiscalYear]) AND
((tblSrvRspns.numFiscalQuarter)=[Forms]![fmnuReportSelect]![lstFiscalQuarter])
AND ((tblQuestions.SrvID)=[Forms]![fmnuReportSelect]![cboSrvID]) AND
((tblQuestions.QstnType)="Stat" Or (tblQuestions.QstnType)="Demo"))
GROUP BY tblQuestions.QstnID, tblQuestions.QstnLvl1, tblQuestions.QstnLvl2,
tblQuestions.QstnLvl3, tblQuestions.QstnText, tblResponses.Rspns,
tblQuestions.SrvID, tblSrvRspns.numFiscalYear, tblSrvRspns.numFiscalQuarter
PIVOT "Number of Responses" In ("Number of Responses");

The field values are questions I ask in the survey, for example "What are
your goals?"

Duane wrote:

The layout preview doesn't rely on actual records and data. Use it only to
get the layout right. Ignore the data.

Could you share the sql view of your crosstab? What are some sample
record/field values that result in the squares?

 

[Duane Hookom]

Thanks for the survey app comments. I still don't know which field results
in the squares. I expect someone has copied and pasted text so you have
maybe Chr(10) without a corresponding Chr(13) or vice-versa.

--
Duane Hookom
MS Access MVP
--

Duane Hookom, the database I designed comes from your Survey database, it
is
great. I have added a few things, here is the sql from the crosstab
query.

PARAMETERS Forms!fmnuReportSelect!cboSrvID Long;
TRANSFORM Count(tblResponses.Rspns) AS CountOfRspns
SELECT tblQuestions.QstnID, tblQuestions.QstnLvl1, tblQuestions.QstnLvl2,
tblQuestions.QstnLvl3, tblQuestions.QstnText, tblResponses.Rspns,
tblQuestions.SrvID
FROM tblSrvRspns INNER JOIN (tblQuestions INNER JOIN tblResponses ON
tblQuestions.QstnID = tblResponses.QstnID) ON tblSrvRspns.RspnsID =
tblResponses.RspnsID
WHERE
(((tblSrvRspns.numFiscalYear)=[Forms]![fmnuReportSelect]![lstFiscalYear])
AND
((tblSrvRspns.numFiscalQuarter)=[Forms]![fmnuReportSelect]![lstFiscalQuarter])
AND ((tblQuestions.SrvID)=[Forms]![fmnuReportSelect]![cboSrvID]) AND
((tblQuestions.QstnType)="Stat" Or (tblQuestions.QstnType)="Demo"))
GROUP BY tblQuestions.QstnID, tblQuestions.QstnLvl1,
tblQuestions.QstnLvl2,
tblQuestions.QstnLvl3, tblQuestions.QstnText, tblResponses.Rspns,
tblQuestions.SrvID, tblSrvRspns.numFiscalYear,
tblSrvRspns.numFiscalQuarter
PIVOT "Number of Responses" In ("Number of Responses");

The field values are questions I ask in the survey, for example "What are
your goals?"

Duane wrote:

The layout preview doesn't rely on actual records and data. Use it only to
get the layout right. Ignore the data.

Could you share the sql view of your crosstab? What are some sample
record/field values that result in the squares?

--
Duane Hookom
MS Access MVP

I have a report based on a cross tab query that up until yesterday was
working fine. Now when I run the report one of the text boxes does not
show
the required text, it only shows a Square, 1 Square for each line of
text.
I
checked the cross tab query and the cross tab query does the same thing.

I tried replacing the text box from the field list but the same thing
happened.
The "layout preview" in the report does show the text.

What is wrong? Any ideas to fix?