Andre
Whether or not the short text box has data has nothing to do with if it shows or
not. Did you set the ControlSource to the right field? Is there data in that
field?
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of koshacc
Sent: Saturday, September 29, 2012 4:24 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: can I hide overlapping field dependin gon field
value in continuous form.
Yes, there appears to be no conten in teh text box of short contacts.
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "wrmosca" <wrmosca@...>
wrote:
>
> Andre
>
> By "blank", do you mean the text box is not showing?
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "koshacc" <andreandpaula@>
wrote:
> >
> > Hi
> > Bill
> >
> > Sorry for long delay, but I was ill and then busy. This code is not quite
working. What it is doing is keeping the short fields blank all the time.
> >
> > Private Sub Form_Current()
> >
> > Me.Short_contact.visible = _
> > ((Len(Me.Parent_report) & vbNullString) = 0)
> >
> >
> > End Sub
> >
> > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca" <wrmosca@>
wrote:
> > >
> > > Andre
> > >
> > > You could use the form's Current event to show or hide the short field
depending on if there is anything in the complex field.
> > >
> > > Private Sub Form_Current()
> > > Me.ShortField.Visible = _
> > > (Len(Me.ComplexField) & vbNullString) = 0)
> > >
> > > End Sub
> > >
> > > The short field's visiblitiy is dependent on whether there is anything in
the complex fiels or not.
> > >
> > > Private Sub Form_Current()
> > > Me.ShortField.Visible = _
> > > (Len(Me.ComplexField) & vbNullString) = 0)
> > >
> > > End Sub
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "koshacc" <andreandpaula@>
wrote:
> > > >
> > > > I have a continuous form which displays details of client contacts.
There are two types of contact -short and complex. To make the layout work I
have placed the short field on top of the complex field (memo fields) to make
the viewing easier. This works fine and I am happy with this layout. (naturally
the short field is completely blank when data is in the complex field.)
> > > >
> > > > Problem is the short and complex fields can be long and will have a
scroll bar but because the short field is on top of the complex field when ever
you click in the area the short field is activated not the complex field.
> > > >
> > > > Is there anyway I can push the short field to the back or not have it at
all when the complex field has data.
> > > >
> > > > I was hoping the paint event would help but it does not.
> > > >
> > > > Andre (MSAccess 2010)
> > > >
> > >
> >
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar