Results 1 to 2 of 2
2002-07-24, 05:43 #1
- 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"
2002-07-24, 11:00 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 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 http://www.Liquorman.net/Tips.html; 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