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