Reports

R

Roger Bell

1. I have check boxes included in a report and want to
remove the borders and just leave the tick. How can i do
this?

2. I have provision on a report for up to 6 childrens
names, listed one under the other in a column format.
How can i close up the space in the report if for example
only 3 names apply to a particular record.

Any advice would be most appreciated
 
R

rowiga

1. I don't know of a way to remove the border from the checkbox but you can
work around that. Put an unbound text box in the place where you want the
tick mark to appear and size it appropriately. In the Font Name property of
this control put "Wingdings". You may also want the font weight to be Bold.
Put a conditional statement in the Control Source such as:

=iif([MyYesNoColumnName]="True","keystroke Alt+0252","")

With the font set as Wingdings the checkmark will appear when you hold down
the Alt key and press 0252.

2. It sounds like your database design needs some work. You should be able
to include as many or as few records within a group as necessary on normally
designed databases. I'm not sure how your report is set up but you can try to
set the "Can Shrink" property to Yes on all six controls.
 
Top