I want to change the height of a control on a form when I enter the control and then change it back again once I exit the control.
I'm using on enter and on exit events to do this, but need some help with two problems:
Firstly I started by entering ControlName.Height = 7 but this made the control disappear - I then realised that this measurement isn't centimetres, but something else - what is the something else and how many something elses per centimetre?
Secondly, when I modify the height of the Control I also need to modify the height of the Detail section. I have managed to do this using:
Detail.Height = 1000
Detail.ControlName = 900
The problem I have is that if I choose a record further down the list, the chosen record can disappear off the screen as the other records also expend to a height of 1000. How can I make the chosen record move to the top of the screen so that the expansion will not have an effect as the record to be edited will be visible.