Reports

[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

 

[Joseph Meehan]

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

I don't think you can directly do it, but you could try using a text box
and the square root or other symbol displayed when the check box is -1 and
not displayed when the check box is 0.

 

[Guest]

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.

 

[Joseph Meehan]

Roger Bell wrote:
....

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

Do you have a table with the names of children in different fields?

I suggest you re-organize this arrangement into a parent - child table
arrangement. That way you will not be limited to just 6 children, you will
eliminate you problem on the form as you can use groupings to allocate the
room needed and you will be following a better normalization table design.

Access will even make this easy for you as it has a normalization wizard
to make the new table and populate it with the names all linked to the right
patents.