I am developing a database for a user who previously used an off the shelf piece of software which didn't entirely fit with his method of working. He's happy with what I am doing but he has been spoilt rotten by the nice to haves he currently experiences with his off the shelf package. One is getting a 'best fit' for his forms.
Currently the piece of software fits the form on to one screen (widthways if that's a word). It looks pretty sophisticated in that it dynamically resizes each column width as you scroll up and down. Very rarely do you have to scroll left to right and back. The design I have fits my screen but if there are any long customer names they get truncated. Conversely if displaying a screen of very short customer names there's a lot of white space.
I've read something about setting the FitToScreen property but I guess that's for size of monitor. I've tried me.controname.columnwidth = -2 but presumably that doesn't work on a continuous form. I've looked at anchoring stretching to fit can grow can shrink but can't find any examples of it working and I've tried in vain myself.
Is it possible?
Currently the piece of software fits the form on to one screen (widthways if that's a word). It looks pretty sophisticated in that it dynamically resizes each column width as you scroll up and down. Very rarely do you have to scroll left to right and back. The design I have fits my screen but if there are any long customer names they get truncated. Conversely if displaying a screen of very short customer names there's a lot of white space.
I've read something about setting the FitToScreen property but I guess that's for size of monitor. I've tried me.controname.columnwidth = -2 but presumably that doesn't work on a continuous form. I've looked at anchoring stretching to fit can grow can shrink but can't find any examples of it working and I've tried in vain myself.
Is it possible?