Hi Forum, MS Access 2010 accdb
In a Continuous Form I want to Include (or Not) a memo under each record.
If included, the Detail Height and a Line Top need to change ie, fill the space provided.
This code is half working. it appears even thought the Text Box control is Not Visible and its Height are changed (or should be) the Detail Height does not reduce.
Appreciate any advice on how to resolve.
In a Continuous Form I want to Include (or Not) a memo under each record.
If included, the Detail Height and a Line Top need to change ie, fill the space provided.
This code is half working. it appears even thought the Text Box control is Not Visible and its Height are changed (or should be) the Detail Height does not reduce.
Code:
If Me.cmdShowNotes.Caption = "Include Notes" Then
Me.Detail.Height = 1.4
Me.lineUnderBuildRecord.Top = 1.3
Me.memBuildMemo.Height = 0.556
Me.memBuildMemo.Visible = True
Me.cmdShowNotes.Caption = "Hide Notes"
ElseIf Me.cmdShowNotes.Caption = "Hide Notes" Then
Me.memBuildMemo.Height = 0.001
Me.Detail.Height = 0.7
Me.lineUnderBuildRecord.Top = 0.6
Me.memBuildMemo.Visible = False
Me.cmdShowNotes.Caption = "Include Notes"
End If
Appreciate any advice on how to resolve.