Report probems

  • Thread starter Thread starter Jim Jones
  • Start date Start date
J

Jim Jones

I am working on a report which consists of text output in
clear boxes on a shaded background. I am using text boxes
containing different parts of the report all placed in a
larger text box which provides the shaded background. Each
of the smaller text boxes then contain other text boxes
and labels which provide the substance of the report.
Everything is reported correctly excect in one text box
where I have 3 columns of small text boxes which use text
manipulation functions MID, TRIM, UCASE, etc) to format
the contents of 10 similar fields in my query. The first
box in the first column are LEFT([syll1],4,2); the next is
LEFT([[syll2],4,2), etc up to LEFT([syll10,4,2) - total of
10 rows. The first rows works exactly as expected, the
second row (and the rest of the table) returns #Error. If
I remove the LEFT and just return the value of the field
without formatting, the field value is returned correctly.

My other problem is that often I cannot get visible output
from a text box placed inside a larger textbox.

Any help would be much appreciated. There must be a
better way of getting printing text in clear boxes on a
shaded backround.

In some despair

Jim Jones
Gaborone
Botswana
 
I'm not sure why you are using so many text boxes layered on text boxes. If
you need shaded background areas, you can use rectangles. Also, the Left()
function uses only two arguements Left([syll1],4). I'm not sure why you have
the extra ",2" in there. Do you need to use the Mid() function?
 
Back
Top