Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2008

Tip: Looking for answers? Try searching our database.

Conditional formatting on Continuous forms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alex - 05 May 2008 20:58 GMT
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 - 06 May 2008 00:30 GMT
>>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
Signature

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
[quoted text clipped - 22 lines]
>
> Many thanks
alex.999@hotmail.co.uk - 06 May 2008 16:25 GMT
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 <KARLDE...@discussions.microsoft.com>
wrote:
> >>I have tried If me.due=1 then me.check1.left=300.....
>
[quoted text clipped - 32 lines]
>
> - Show quoted text -
KARL DEWEY - 06 May 2008 21:08 GMT
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.

Signature

KARL DEWEY
Build a little - Test a little

> Thanks Karl,
>
[quoted text clipped - 43 lines]
> >
> > - Show quoted text -
alex.999@hotmail.co.uk - 08 May 2008 21:48 GMT
On May 6, 9:08 pm, KARL DEWEY <KARLDE...@discussions.microsoft.com>
wrote:
> You might try using calculated fields in your query and set text boxes
> property to flat, transparent, and bold.  
[quoted text clipped - 58 lines]
>
> - 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.