I'm using Access XP and having weirdness with the Detail_Format Event.
In the Detail_Format sub, I set the value of several textboxes. This seems to retrigger the Format event, so I
if FormatCount>1 then
cancel = true
exit sub
endif
before setting any textboxes like this....
Select Case intPageNum
Case 1
'--Top
Me.tRoll1 = !Road1Roll
Me.tNeg1 = !Road1Neg
Me.tDesc1 = !Road1
Me.tLooking1 = !Road1Looking
Me.tPic1 = !Road1Pic
Case 2
'--Top
Me.tRoll1 = !Super1Roll
Me.tNeg1 = !Super1Neg
Me.tDesc1 = !Super1
Me.tLooking1 = !Super1Looking
Me.tPic1 = !Super1Pic
etc.
It sets textbox values based on an OpenArg value of "1" to "7"
Works great for 2 to 7 in Normal View (printing) and for all values in Preview Mode, but if I pass it an OpenArg of 1 then Open Normal it gives a blank page!
In the Detail_Format sub, I set the value of several textboxes. This seems to retrigger the Format event, so I
if FormatCount>1 then
cancel = true
exit sub
endif
before setting any textboxes like this....
Select Case intPageNum
Case 1
'--Top
Me.tRoll1 = !Road1Roll
Me.tNeg1 = !Road1Neg
Me.tDesc1 = !Road1
Me.tLooking1 = !Road1Looking
Me.tPic1 = !Road1Pic
Case 2
'--Top
Me.tRoll1 = !Super1Roll
Me.tNeg1 = !Super1Neg
Me.tDesc1 = !Super1
Me.tLooking1 = !Super1Looking
Me.tPic1 = !Super1Pic
etc.
It sets textbox values based on an OpenArg value of "1" to "7"
Works great for 2 to 7 in Normal View (printing) and for all values in Preview Mode, but if I pass it an OpenArg of 1 then Open Normal it gives a blank page!
