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