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@yahoo.com
> 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
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar