By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,903 Members | 2,097 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,903 IT Pros & Developers. It's quick & easy.

Form Detail Section formatting

P: n/a
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

Jun 2 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Jun 2 '06 #2

P: n/a
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

Jun 2 '06 #3

P: n/a
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


Jun 2 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.