Memo box not showing all

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a memo box on a form and print a report from a query. when the report
prints it only prints part of the info in the memo box. I have set the report
field properites to can grow "YES" but it still is leaving most of the memo
information out
once the info runs through a query does it limit the number of spaces in a
field?
Thanks
Tman
 
There is virtually no limit to the number of characters displayed in a text
box on a report. Please check your report's record source in datasheet view
to see if you find more than 255 characters displaying in the query.

If the query is your issue, you can either remove "group by", "Distinct",
etc from the SQL or post your SQL view to us for more assistance.
 
It does limit the query to 255 characters Here is the sql view
IT IS THE REMARKS SECTION AT ISSUE
SELECT Aviationtbl.NVGHours, Aviationtbl.Runningtotalaviagastotal,
Aviationtbl.Flight_Number, Aviationtbl.use, Aviationtbl.Flight_Duration,
Aviationtbl.[Flight Number], Aviationtbl.Runningtotalaviagastotal,
Aviationtbl.Date, Aviationtbl.[Aircraft ID Number], Aviationtbl.Hangar,
Aviationtbl.[Pilot Name], Aviationtbl.[Requested By ?], Aviationtbl.[Type of
Mission], Aviationtbl.[Flight Location by County], Aviationtbl.Remarks
FROM Aviationtbl
GROUP BY Aviationtbl.NVGHours, Aviationtbl.Runningtotalaviagastotal,
Aviationtbl.Flight_Number, Aviationtbl.use, Aviationtbl.Flight_Duration,
Aviationtbl.[Flight Number], Aviationtbl.Runningtotalaviagastotal,
Aviationtbl.Date, Aviationtbl.[Aircraft ID Number], Aviationtbl.Hangar,
Aviationtbl.[Pilot Name], Aviationtbl.[Requested By ?], Aviationtbl.[Type of
Mission], Aviationtbl.[Flight Location by County]
HAVING (((Aviationtbl.Date) Between [Enter Start Date] And [Enter Ending
Date]) AND ((Aviationtbl.[Aircraft ID Number]) Like "*" & [EnterAircraft
ID(OR LEAVE BLANK FOR ALL RECORDS)] & "*") AND ((Aviationtbl.[Pilot Name])
Like "*" & [Enter Pilot Badge # (OR LEAVE BLANK FOR ALL RECORDS)] & "*"));
 
Is there a reason you are creating a totals query? You aren't performing
any sums or counts.

--
Duane Hookom
MS Access MVP
--

t848 said:
It does limit the query to 255 characters Here is the sql view
IT IS THE REMARKS SECTION AT ISSUE
SELECT Aviationtbl.NVGHours, Aviationtbl.Runningtotalaviagastotal,
Aviationtbl.Flight_Number, Aviationtbl.use, Aviationtbl.Flight_Duration,
Aviationtbl.[Flight Number], Aviationtbl.Runningtotalaviagastotal,
Aviationtbl.Date, Aviationtbl.[Aircraft ID Number], Aviationtbl.Hangar,
Aviationtbl.[Pilot Name], Aviationtbl.[Requested By ?], Aviationtbl.[Type
of
Mission], Aviationtbl.[Flight Location by County], Aviationtbl.Remarks
FROM Aviationtbl
GROUP BY Aviationtbl.NVGHours, Aviationtbl.Runningtotalaviagastotal,
Aviationtbl.Flight_Number, Aviationtbl.use, Aviationtbl.Flight_Duration,
Aviationtbl.[Flight Number], Aviationtbl.Runningtotalaviagastotal,
Aviationtbl.Date, Aviationtbl.[Aircraft ID Number], Aviationtbl.Hangar,
Aviationtbl.[Pilot Name], Aviationtbl.[Requested By ?], Aviationtbl.[Type
of
Mission], Aviationtbl.[Flight Location by County]
HAVING (((Aviationtbl.Date) Between [Enter Start Date] And [Enter Ending
Date]) AND ((Aviationtbl.[Aircraft ID Number]) Like "*" & [EnterAircraft
ID(OR LEAVE BLANK FOR ALL RECORDS)] & "*") AND ((Aviationtbl.[Pilot Name])
Like "*" & [Enter Pilot Badge # (OR LEAVE BLANK FOR ALL RECORDS)] & "*"));


Duane Hookom said:
There is virtually no limit to the number of characters displayed in a
text
box on a report. Please check your report's record source in datasheet
view
to see if you find more than 255 characters displaying in the query.

If the query is your issue, you can either remove "group by", "Distinct",
etc from the SQL or post your SQL view to us for more assistance.
Click to expand...
Click to expand...
 
Back
Top