Formatting one line in a Continuous Form 1

[beansmom]

I have a form that contains a continuous form as a subform. The subform is a survey that has a number of questions for the user to respond to. For each record there is a question, status, and text field. The question field is the question number, the status field is where the user answers, and the text field contains the question text. The user tabs from status field to status field. The text and question fields are locked.

I need to be able to alert the user as they move to certain questions. For example, when they tab to the status field of question number 3, I need the question number to turn red. However, it turns all the question numbers on the survey red. I tried conditional formatting, but for various reasons it is not the solution for me.

Thanks for your help.

 

[SarahG]

When you change the format of a control, it changes every instance of that control so you can expect Access to format all your question numbers red.
One way to get around this is to change the subform to a pop-up, in which case you can make it a single record form, but this may be cumbersome for the user.
The alternative is to create different subforms for each type of question. The underlying source of each subform could be a query selecting from the question table for a particular type. You can play around with settings taking off the navigation buttons, individual subform titles etc to make it look neat.

 

[beansmom]

Thanks for the help. However, I think I am just going to have to abandon the continuous form and go back to using a single form. The continuous form is too restricting.

 

[TheAceMan1]

How are ya beansmom . . . . .

Your real problem is [purple]the criteria that will determine changing a question number to red.[/purple]

Since this appears to be [blue]a little indeterminate[/blue], might I suggest you add a [purple]Yes/No[/purple] (checkbox) field to the associated table. This way you can [blue]tag at will[/blue] and [purple]use the tags for detection[/purple] in the form. [blue]Now you could even use Conditional Formatting to tag them all![/blue]

See Ya! . . . . . .

 

[mustangcoupe]

OK, I have had the same problem on the project I am working on... I want to change the background color for a control on a continuous form BUT if one value fals with in my condition (pass/Fail) then they all get the formatting...

Here is what I found in same sample code...

I set the combo box to transparent background. I placed a text box sized exactly the same Behind the combo box. with its background color the color as the rest of my controls on the form.

Important stuff!!!

The format(I remember this was critical as noted in the sample I saw) of the text box is ;"ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ"
Font is Terminal
Font size(you may have to change this) 12
Text box fore color (for red) 255
Control source will be your identifier of when the color will change..... for mine I use =[Result]>1 so If the field result is >1 then I want to use fore color (red is my choice) otherwise back color.

you will have to figure out your control source



--Todd


TechnicalUser pretending to be a programmer(shhh… the boss doesn’t know yet)