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