[AccessD] Set height of txt boxes equal

Well apart from the fact that controls don't have a property called
'lngmyhight', the answer is "Yes, of course!"

Once you've calculated a new height for your text controls, naturally you
can then set them all using code like your loop. How else would you plan on
doing it?

Lambert

> -----Original Message-----
> From:	accessd-bounces at databaseadvisors.com
> [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
> Sent:	Monday, February 28, 2005 11:13 AM
> To:	'Access Developers discussion and problem solving'
> Subject:	RE: [AccessD] Set height of txt boxes equal
> 
> So if I modify the code to calculate a specific text box
> Can I then say 
> 
> 	Me.othertextbox.lngmyheight = xxx
> 
> 
> Dim frm As Form
> Dim lngMyHeight as long
> Dim ctl as Control
> 
> lngMyHeight= xxxxx
> 
> For each ctl in Me.Controls
>   if ctl.ControlType = acTextBox then
> 	ctl.Height=lngMyHeight 
>   end if
> Next
> 
> HTH
> 
> -- Andy Lacey
> http://www.minstersystems.co.uk 
>