Conditional formatting on Continuous forms

[Alex]

I have a number of questions that need responses to be entered at certain
points during a process. I would like to have a checkbox for each question
positioned under 'seperate columns' depending when in the process the
question needs to be addressed. I have used a continuous form to display the
questions as there are a few pages of them to be completed.

The form I have in mind would look like this:

Question Step1 Step2 Step3 Due
Q1 O 1
Q2 O 1
Q3 O 2
Q4 O 3

The 'Due' column is the relevant step when the check box (depicted by an 'O'
above) is to be completed and also determines which column the checkbox
should be displayed under.

I have tried If me.due=1 then me.check1.left=300..... and so on for each
value. However, the form looks at the first value and applies it to each line
rather than checking the value of 'Due' for each line.

Any help would be much appreciated, I need to use a form layout like this
for clarity of data entry and eventually transfer it to a report.

Many thanks

 

[KARL DEWEY]

I have tried If me.due=1 then me.check1.left=300.....
Donna but try this --
If me.due>0 then me.check1.left=[Due]*300

 

[alex.999]

Thanks Karl,

I tried your suggestion, but the value set against the first question
is used for the remaining questions.
I need a way of using the value given in [due] for each line to be
utilised for all the questions.

Dave.

Donna but try this --
       If me.due>0 then me.check1.left=[Due]*300
--
KARL DEWEY
Build a little - Test a little

I have a number of questions that need responses to be entered at certain
points during a process. I would like to have a checkbox for each question
positioned under 'seperate columns' depending when in the process the
question needs to be addressed. I have used a continuous form to displaythe
questions as there are a few pages of them to be completed.

The form I have in mind would look like this:

Question            Step1        Step2        Step3          Due
Q1                        O                                                1
Q2                        O                                                1
Q3                                         O                               2
Q4                                                         O               3

The 'Due' column is the relevant step when the check box (depicted by an'O'
above) is to be completed and also determines which column the checkbox
should be displayed under.

I have tried If me.due=1 then me.check1.left=300..... and so on for each
value. However, the form looks at the first value and applies it to eachline
rather than checking the value of 'Due' for each line.

Any help would be much appreciated, I need to use a form layout like this
for clarity of data entry and eventually transfer it to a report.

Many thanks- Hide quoted text -

- Show quoted text -

 

[KARL DEWEY]

You might try using calculated fields in your query and set text boxes
property to flat, transparent, and bold.
The calculation like this --
Step1: IIF([Due]=1, "X", Null) Step2: IIF([Due]=2, "X", Null)
Step3: IIF([Due]=3, "X", Null)

When there is data the'X' will be visible.

--
KARL DEWEY
Build a little - Test a little

Thanks Karl,

I tried your suggestion, but the value set against the first question
is used for the remaining questions.
I need a way of using the value given in [due] for each line to be
utilised for all the questions.

Dave.

I have tried If me.due=1 then me.check1.left=300.....

Donna but try this --
If me.due>0 then me.check1.left=[Due]*300
--
KARL DEWEY
Build a little - Test a little

I have a number of questions that need responses to be entered at certain
points during a process. I would like to have a checkbox for each question
positioned under 'seperate columns' depending when in the process the
question needs to be addressed. I have used a continuous form to display the
questions as there are a few pages of them to be completed.

The form I have in mind would look like this:

Question Step1 Step2 Step3 Due
Q1 O 1
Q2 O 1
Q3 O 2
Q4 O 3

The 'Due' column is the relevant step when the check box (depicted by an 'O'
above) is to be completed and also determines which column the checkbox
should be displayed under.

I have tried If me.due=1 then me.check1.left=300..... and so on for each
value. However, the form looks at the first value and applies it to each line
rather than checking the value of 'Due' for each line.

Any help would be much appreciated, I need to use a form layout like this
for clarity of data entry and eventually transfer it to a report.

Many thanks- Hide quoted text -

- Show quoted text -

 

[alex.999]

You might try using calculated fields in your query and set text boxes
property to flat, transparent, and bold.  
The calculation like this --
   Step1: IIF([Due]=1, "X", Null)        Step2: IIF([Due]=2, "X", Null)      
   Step3: IIF([Due]=3, "X", Null)  

When there is data the'X' will be visible.

--
KARL DEWEY
Build a little - Test a little

Thanks Karl,

I tried your suggestion, but the value set against the first question
is used for the remaining questions.
I need a way of using the value given in [due] for each line to be
utilised for all the questions.

Dave.

I have tried If me.due=1 then me.check1.left=300.....
Donna but try this --
       If me.due>0 then me.check1.left=[Due]*300
--
KARL DEWEY
Build a little - Test a little
:
I have a number of questions that need responses to be entered at certain
points during a process. I would like to have a checkbox for each question
positioned under 'seperate columns' depending when in the process the
question needs to be addressed. I have used a continuous form to display the
questions as there are a few pages of them to be completed.
The form I have in mind would look like this:
Question            Step1        Step2        Step3          Due
Q1                        O                                                1
Q2                        O                                                1
Q3                                         O                               2
Q4                                                         O               3
The 'Due' column is the relevant step when the check box (depicted by an 'O'
above) is to be completed and also determines which column the checkbox
should be displayed under.
I have tried If me.due=1 then me.check1.left=300..... and so on for each
value. However, the form looks at the first value and applies it to each line
rather than checking the value of 'Due' for each line.
Any help would be much appreciated, I need to use a form layout likethis
for clarity of data entry and eventually transfer it to a report.
Many thanks- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

Hi Karl,

Still no joy.
However, the checkbox is there to be populated only when the question/
action has been completed.

I need a way for each line to be referenced individually to determine
the position of the checkbox rather than having them all based in the
first line.

It looks like I'm not going to be able to do this the way I wanted -
unless anyone else has any ideas.


Thanks
Alex.