Conditional formatting on Continuous forms

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

I have tried If me.due=1 then me.check1.left=300.....
Donna but try this --
If me.due0 then me.check1.left=[Due]*300
--
KARL DEWEY
Build a little - Test a little


"Alex" wrote:

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

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.

On May 6, 12:30*am, KARL DEWEY
wrote:
I have tried If me.due=1 then me.check1.left=300.....

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



"Alex" wrote:
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 -

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


" wrote:

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.

On May 6, 12:30 am, KARL DEWEY
wrote:
I have tried If me.due=1 then me.check1.left=300.....

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



"Alex" wrote:
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 -

On May 6, 9:08*pm, KARL DEWEY
wrote:
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



" wrote:
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.

On May 6, 12:30 am, KARL DEWEY
wrote:
I have tried If me.due=1 then me.check1.left=300.....

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

"Alex" wrote:
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 -- 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.