Prev: How to sort records in a report
Next: Content Advisor Password...
From: deb on 13 Apr 2010 10:40
access 2003

How can I make a bound textbox named WarrantyTerms width change if checkbox
BB1 and BB2 and BB3 are false?

If checkbox BB1 and BB2 and BB3 are false, I need them to Not be visible and
the WarrantyTerms textbox width to be 7", left 1.2917", top 0.5396", height
0.5826"

If checkbox BB1 or BB2 or BB3 =true then they will be visible and the
WarrantyTerms textbox width to be 4.6667", left 3.625", top 0.5396", height
0.5826"

How can I accomplish this?


--
deb
From: ghetto_banjo on 13 Apr 2010 10:59
You probably want to check for those checkboxes being false in a
couple of different places. In the After Update events for all three
and then possibly the On Current or Load events as well.

You can change the width of a text box by something like:

if Not BB1 AND Not BB2 AND Not BB3 then
WarrantyTerms.Width = 2880
else
WarrantyTerms.Width = 1440
end if


I am not sure what the correct term is for the unit of measurement,
but i know that 1440 = 1 inch.

Similarly there are Left, Top, and Height properties for textboxes as
well that you manipulate the same way in VB code.
 | 
Pages: 1
Prev: How to sort records in a report
Next: Content Advisor Password...