I seem to have encountered peculiarities when using the new Access 2000 conditional formatting on a continuous form:
1) I use flat, white-background controls with transparent border style; I leave small gaps in their horizontal spacing and set the Detail section slightly taller than the height of the controls. In this way I create grid on the continuous form out of the Detail’s back colour showing in the small gaps between the controls.—When I then set conditional formatting for the controls this careful spacing between the controls becomes distorted: the controls seems to be set at peculiar horizontal and vertical positioning with respect to each other.
This defect is even more apparent when I set margins for the text position within the controls: these margins seem to disappear—the text is butted to the left and, worse, where the margin had been, the background shows through, making my careful spacing much, much worse again.
2) The conditional formatting does not seem to work if there is a function in the control source of the control, rather than a bound field.—As I am experimenting with the form, I have just realized a small variation on the preceding statement: I am working with the conditional formatting at runtime. I have attached the condition/formatting information to the form’s current event. If I make a record current, the formatting for the control where I have placed the function works! (The formatting for the bound-controls-to-a-field work as soon as I open the continuous form in ALL the displayed records, whether they are current or not.)—Actually, this feature is true (ie the formatting for a control with a function in it) if I attach the condition/formatting information to the control at design time, too.
I would very much appreciate comments on these two conditions.
Thank you, Pavla.
1) I use flat, white-background controls with transparent border style; I leave small gaps in their horizontal spacing and set the Detail section slightly taller than the height of the controls. In this way I create grid on the continuous form out of the Detail’s back colour showing in the small gaps between the controls.—When I then set conditional formatting for the controls this careful spacing between the controls becomes distorted: the controls seems to be set at peculiar horizontal and vertical positioning with respect to each other.
This defect is even more apparent when I set margins for the text position within the controls: these margins seem to disappear—the text is butted to the left and, worse, where the margin had been, the background shows through, making my careful spacing much, much worse again.
2) The conditional formatting does not seem to work if there is a function in the control source of the control, rather than a bound field.—As I am experimenting with the form, I have just realized a small variation on the preceding statement: I am working with the conditional formatting at runtime. I have attached the condition/formatting information to the form’s current event. If I make a record current, the formatting for the control where I have placed the function works! (The formatting for the bound-controls-to-a-field work as soon as I open the continuous form in ALL the displayed records, whether they are current or not.)—Actually, this feature is true (ie the formatting for a control with a function in it) if I attach the condition/formatting information to the control at design time, too.
I would very much appreciate comments on these two conditions.
Thank you, Pavla.
