On format, fileds that can be used

[markjkubicki]

Is this correct (?):



In the detail section's on format event, I have code that formats the text to the manner that I want it to appear on the report.
(the formatting has more to do with sentance structure and grammer, rather than font. ex: instead of the [LeadTime] printing as "1" or "2", it prints as "...there is 1 week" or "... there are 2 weeks"

What I'm noticing is that even though [LeadTime] is in the report's record source, unless there is also a textbox in the detail section whose control source is [LeadTime], I cannnot reference [Leadtime] in my code (it results in an error).

This is not such a big deal, except that because of the many number of fileds in my report, a vast amount of non-visible textboxes (with a height of 0") needs to be created; and these can be very difficult to keep track of; nevermind cumbersome to set up.

Am I seeing things correctly?
Is there a work-around?

many thanks in advance,
mark

[NTC]

yes I believe you are correct in your assessment.

in general I leave those fields visible as a trouble shoot aid - until absolutely everything works - and then I make not visible. I don't go for the 0 size - I let them be bigger to make easier to find in design view.

in terms of a work around - I don't think in reports. I think you would have to work with calculated fields in the record set query itself; which may not be totally satisfactory but might aid in avoiding a large quantity of non-visible fields itself.

hope this helps.