Yes, there appears to be no conten in teh text box of short contacts.
--- In MS_Access_Professionals@yahoogroups.com, "wrmosca" <wrmosca@...> wrote:
>
> Andre
>
> By "blank", do you mean the text box is not showing?
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.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, "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, "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)
> > > >
> > >
> >
>
Tidak ada komentar:
Posting Komentar