Calculation on a continuous form (Acc 97 sr2 on 95b)

Topic

New Reply

I am trying to create a form that shows Employee Name, Total Hours allocated, and a bar graph as:

boxgraph.width = [totalofhours]

calculated on form_Current

What I am getting is: the value for [totalofhours] is taken from the first record and all the boxes are shown as the same value.

How can I get the value for the box.width to be calculated for each record on the continuous form? (about 15).

Reply | Quote

Replies

Only the contents (data) of controls vary by record in a continuous form (because the value depends on the control source). Formatting of a control, such as Width, is the same for all records.

(Note: you may have seen examples of changing the background color of the detail section or of controls in a continuous form. This is all done by clever manipulation of the control source of controls. See for instance Mark Liquorman’s great demo, downloadable from http://www.Liquorman.net/Tips.html%5B/url%5D; look for ‘Highlight a Single Row’.)

You might try the following:

• Place an unbound text box in the detail section of the form.
• If you like, you can make its border and background style transparent.
• Set its font to Terminal; you can experiment with font size later.
• Set its control source to
  =String(Nz([TotalOfHours],0),”

Reply | Quote