Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Brisbane, Queensland, Australia
    Thanked 0 Times in 0 Posts

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

    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).
    "Heading for the deep end"

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

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

    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; look for 'Highlight a Single Row'.)

    You might try the following:
    <UL><LI>Place an unbound text box in the detail section of the form.
    <LI>If you like, you can make its border and background style transparent.
    <LI>Set its font to Terminal; you can experiment with font size later.
    <LI>Set its control source to

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts