ACCESS FEED: RE: [MS_AccessPros] Re: How to display strikethrough when task is completed?

Selasa, 16 April 2013

RE: [MS_AccessPros] Re: How to display strikethrough when task is completed?

Kumar,

Your original question should have included the significant specification of StatusCode = 50. The solution depended on this basic fact.

If your field and value are StatusCode and 50 then try:
=IIf([StatusCode]=50,"----------------------------------------------------------","")

Or

=IIf([StatusCode]=50,String(30,"-"),"")

You can replace the 30 with some other number.

Duane Hookom MVP
MS Access

----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
> From: access_kri@yahoo.com
> Date: Tue, 16 Apr 2013 16:20:16 +0000
> Subject: [MS_AccessPros] Re: How to display strikethrough when task is completed?
>
> Dear Duane,
> Sorry, I didn't understand your solution at first and hence got the idea of using line control, but it didn't work. So I tried your solution again. The strikethrough is visible at all times and not when the status is complete.
>
> I am having a field called Status code and it is storing value of status code 10=Reported, 20=Planned, 30=Scheduled, 40=Inprogress and 50=completed.
>
> I desire that when I update the statuscode field to 50 ie.completed, the jobDescription field should display a strikethrough. For other statuses, it should not display the strike through.
>
> Thanks and Regards,
> Kumar
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
> >
> > Kumar,
> >
> >
> > I'm not sure why you didn't follow the instructions that I provided. I didn't suggest anything involving code. There was no line control. There was nothing to do with a visible property.
> >
> > I had opened my sandbox database, created new form and tested this prior to replying back to your question.
> >
> > Duane Hookom MVP
> > MS Access
> >
> >
> > ----------------------------------------
> > > To: MS_Access_Professionals@yahoogroups.com
> > > From: access_kri@...
> > > Date: Mon, 15 Apr 2013 16:17:12 +0000
> > > Subject: [MS_AccessPros] Re: How to display strikethrough when task is completed?
> > >
> > > Dear Duane,
> > > I included a line on jobDescription textbox and set its visbile property to no. Then on the form current event procedure, I wrote a if statement but it is making the line visible even when the status is other than complete. I am not able to figure it out why. Please guide
> > >
> > > Private Sub Form_Current()
> > > If Statuscode = 50 Then
> > > Line239.Visible = True
> > > Else: Line239.Visible = False
> > > End If
> > >
> > > Regards,
> > > kumar
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> > > >
> > > > Kumar,
> > > >
> > > > You can add a text box behind the JobDescription text box. Set the Control Source of the new text box to:
> > > >
> > > > =IIf([Completed],"----------------------------------------------------------","")
> > > >
> > > >
> > > > Make sure the JobDescription text box background is transparent.
> > > >
> > > > Duane Hookom MVP
> > > > MS Access
> > > >
> > > > -
> > > >
> > > > ---------------------------------------
> > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > From: access_kri@
> > > > > Date: Mon, 15 Apr 2013 13:12:08 +0000
> > > > > Subject: Re: [MS_AccessPros] How to display strikethrough when task is completed?
> > > > >
> > > > > Dear Duane,
> > > > > I want the strikethrough displayed in the form as it is an entry cum dispaly form.
> > > > >
> > > > > Thanks and Regards,
> > > > > Kumar
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> > > > > >
> > > > > > Do you want to display this on a form or report? Duane Hookom MVPMS Access
> > > > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > > > From: access_kri@
> > > > > > > Date: Mon, 15 Apr 2013 07:48:01 +0000
> > > > > > > Subject: [MS_AccessPros] How to display strikethrough when task is completed?
> > > > > > >
> > > > > > > Dear All,
> > > > > > > I am using Laundrylist Access 2007 database. I want that as soon as I update the Status to "Completed", the JobDescription should display a strikethrough. I am now using the conditional formating to change the shade for completed jobs. However, it gives pleasure when you strike off jobs from your pending list. Please help whether I can accomplish this through conditional formating or through VBA.
> > > > > > >
> > > > > > > Thanks and Regards,
> > > > > > > Kumar
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>