Form Detail Section formatting

[2D Rick]

Access2003 and XP
In the detail section of a continuous FORM I have a textbox named
txtTraceType that can have a value of "B" or "L" or "N".
For each record in the detail section I want lines [lineLotNumber] or
[lineSerialNumber] to become visible based on the value of
txtTraceType.

if txtTraceType.Value = "L" then lineLotNumber.Visible = True
or
if txtTraceType.Value = "N" then lineLotNumber.Visible = False and
lineSerialNumber.Visible = False
or
if txtTraceType.Value = "B" then lineLotNumber.Visible = True and
lineSerialNumber.Visible = True

This logic works in a reports Detail_Format section but in a FORM in
behaves differentely.

I'm using the lines as visual cues to what records need Lot Numbers or
Serial Numbers or No data entered into textboxes above these lines.
The cue is a kick back to printed forms manually entered.
Thanks, RICK

[blue875]

I just tested Line.Visible = false, and it made a line go away on my
form. The problem may be in your comparison. Try this:

If StrComp(txtSomething, "B") = 0 Then
lineSerialNumber = true
End If

[blue875]

I just tested Line.Visible = false, and it made a line go away on my
form. The problem may be in your comparison. Try this:

If StrComp(txtSomething, "B") = 0 Then
lineSerialNumber = true
End If

[2D Rick]

If your dealing with a continuous form bound to a table with many
records your solution acts the same way. All records are visible or not
based on the value of the first record.

Rick

bl*****@carolina.rr.com wrote:

I just tested Line.Visible = false, and it made a line go away on my
form. The problem may be in your comparison. Try this:

If StrComp(txtSomething, "B") = 0 Then
lineSerialNumber = true
End If