Search results

You're quite welcome. :)

Since the value in a text box is of type Variant, use a space instead. If you need to make calculations, just use the IsNumber function on each cell.

The label itself doesn't have a Shrink property, but you could set the visible property in VBA to whether or not the text box has a null value. In the report's On Current event, add: Me.LableBillingWeeks.Visible = IsNull(Me.BillingWeeks) That should take care of the label.

I didn't quite think of the grouping maneuver in conjunction with it. I'll try it and let you know.

How is the layout configured? Can you give a screenshot of it?

I tried that, but that way only calculates 1 day per month--either the first or last. I need every day within the month that training has been conducted. I already knew the categories would have to report. I'm just trying to get the "monthly detail" done.

There is a control that inserts a forced page break for reports. In the form design tools section, the page break control is right next to the combo box control

By the way, don't worry about the dynamic listings of each month. I already know how to deal with that.

What specifically are you summarizing? If that's known, you can either retrieve the data from your tables.

Set the Can Shrink property to Yes. It'll disappear if the text box has a null value.

You also may want to use the Round function as well. You have to specify how many decimal places you want. Syntax: Round(number, # of decimal places)

:banghead:Hello, I'm new to this forum. I need to see if this can be feasible. I need an annual training summary report, but with non-aggregate information in the detail, sorted into monthly columns. Here's an example of what I want: ................|...