Report Types

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I would like to create a report that is in two columns and uses periods
between the entries for a cross reference.

Item.............Ref 1
Item2...........Ref2, Ref3

Is there a easy way to do this in Access 2007 or should I use VBA to create
a word document that is formatted this way?

Thanks.
 
How about changing control souces to something like:
=[ItemName] & String(100,".")
Make sure the name of the control is not the same as the name of a field and
don't allow the control to grow.
 
I would like to create a report that is in two columns and uses periods
between the entries for a cross reference.

Item.............Ref 1
Item2...........Ref2, Ref3

Is there a easy way to do this in Access 2007 or should I use VBA to create
a word document that is formatted this way?

Thanks.
Click to expand...

Check out Stephen Lebans site:
http://www.lebans.com/leaderdots.htm
 
Thank you both for the answers.

There are mulitple item references is there a easy way to collect all the
records into one line with commas between the entries:

Item......Ref1, Ref2
 
Back
Top