On format In forms

[rgbanse]

In a report the is and "On Format" option for each section.
Is there a "On Format" work around for forms.
Thx
RGB

 

[RickSpr]

That depends. What do you want to do? You might be able to use the Current event, which is fired off every time you move to another record. Rick Sprague

 

[rgbanse]

Rick,
There's more to be done, but to start out would like to alternate "line" color.
thx
RGB

 

[RickSpr]

"Line" could mean many things. I'm going to guess that you want to alternate the Detail section's BackgroundColor property in a form viewed as Continuous Forms. Sorry, but I don't think that can be done quite that way.

If you're using Access 2000, you might be able to use Conditional Formatting to achieve a similar effect. Conditional Formatting lets you control the background and text colors (plus other font characteristics) of a text box or combo box control, based on the value of the data, the value of an arbitrary expression, or the focused/unfocused state of the control.

If you completely cover your form's Detail section with text boxes, You could then give each text box the same formatting conditions so their backgrounds would all change together. To give you alternation, the formatting condition would an expression that returns whether the current record number is odd or even. Rick Sprague

 

[rgbanse]

It looks like I need to migrate to XP thanks for the input
RGB