| re: Fields as Headers
You can do change the header of the fields by changing the Caption op the
field.
If you using the caption of a field as header text, you can change the
caption in the report.
In the report you have to write VBA code under the event "By printing".
There you have to open a table and some coding to change the caption.
Example
me.Field_x.caption = Rst1.Field_x
The content of Field_x from record set 1 will be placed in the caption of
Fieled_x from the printed table.
I hope this will help you little.
Regards,
Simon
"John M" <jonmit2@bigpond.com> schreef in bericht
news:xxMfd.706$K7.385@news-server.bigpond.net.au...[color=blue]
> I know that you can make a cross tab query and get the fields as headers[/color]
but[color=blue]
> it makes the form or datasheet unusable, ie cant add any data in the
> resulting fields. Is there a way of making a table with fields, from[/color]
another[color=blue]
> table, that can then be used as headers so you can use the resulting[/color]
fields[color=blue]
> for data entry. I only need this for forward planning and the data entered
> would be changed regularly, but not continually added to. I also would[/color]
like[color=blue]
> to be able to change the headers occassionly without having to go behind[/color]
the[color=blue]
> scenes, so to speak, to do that. ie from the users perspective.
> Hope can understand what i am alluding to here!
> Thanks for any help.
>
>[/color]
| 
