Form behaviour

[Middlemarch]

I have a non-modal popup form on top of main form.
If I click something on the main form the caption on the popup form greys out.


Is that normal and can it be restored? Thanks.

[June7]

Normal.
Click back on the popup form.

[Middlemarch]

Yes I know, but how is that done in code so it's automatic

[June7]

If user has clicked on main form, what event do you suppose could be triggered? User can't really do anything on the main form.

Maybe user should not be able to click on main form when popup is open. Maybe popup should be modal.

[Middlemarch]

The main form changes what the Popup Form sees.
That won't work if it's modal.

[June7]

If you want to allow user to click back onto main form and do something, then maybe popup shouldn't be set as Popup.

What process are you trying to code?

[Middlemarch]

That's interesting, if it's not popup might that work? I'll try it.
Normally only one item is displayed (in a text box). But if there's many a click in the textbox opens Form with a Listview.
It displays a field from an mp3 ID3tag, where the filename(s) are read into an array. So nothing is bound.
I did think about a listbox instead of a text box, and a drop down if items > 1. Now I'm not sure so will both, unless you have a recommendation.

[Middlemarch]

OK, removing Popup made it full screen and a mess.
Now trying a listbox but finding it very difficult to assign the height properly. Can access not do that automatically ?
I read a listbox scrollbar exists but not how to turn it on, and I'm not seeing it.
Tried Google for this but while there's a lot there's nothing useful about height/scroll for value list I can find.

[davegri]

No automatic height for listbox. Scroll bar will appear automatically when needed to see rows exceeding height.

[Middlemarch]

Thanks davegri. I do get a scrollbar now but would like to calculate a height (based on font size * number of items ??).
So that >12 rows invoke a scrollbar. This was changed from a textbox and if one item, that's fine, the listview displays just like it. Otherwise I'm still mucking about trying to get it right.

Would a combo box be easier to manage ?

[davegri]

Advantage of listbox is that multiple rows can be selected. Combobox can do that too if evils of multi-value table fields are invoked.
Yes you can, of course, calculate height of listbox.

[Middlemarch]

I'll check out a combo and pick whatever works best to display data.
Re listbox, what's the formula to calculate height exactly? Can't find it on Google and trying different guesses.

[davegri]

I'll check out a combo and pick whatever works best to display data.
Re listbox, what's the formula to calculate height exactly? Can't find it on Google and trying different guesses.

While I asserted that the height could be calculated, I had no formula in mind. I would work it out via trial and error.

[June7]

Read and set listbox Height property in VBA as TWIPS. 1440 TWIPS per inch.
Fonts are measured in points, approx 72 points per inch.
https://fontsaga.com/font-size-chart-to-inches/

[isladogs]

I'll check out a combo and pick whatever works best to display data.
Re listbox, what's the formula to calculate height exactly? Can't find it on Google and trying different guesses.

This article may help Accurately Move Forms & Controls (isladogs.co.uk)
See sections on trips, pixels & points together with the use of the hidden Wizhook function to automatically calculate the height of each row depending on the font name, style & point size