SubForm: Preserving Selection Rectangle When Focus Lost?

[(PeteCresswell)]

One of my typical screens has a list of "Things" on the left side
of the form and detail fields on the right side.

As the user walks the list, details on the right side are updated
to reflect the info behind the currently-selected "Thing".

Works find. Visually-intuitive bc the ThingName on the list
remains highlighted even though the user may click on one of the
detail fields.

On this app, one of the thing's properties is a
"NeedsSpecialAttention" switch. If the switch is set, we need
to emphasize that "Thing" - preferably on the list.

To that end, I'm using a subform instead of a list and setting
ThingName's .FontBold=True and .ForeColor=BrightRed via
Format|ConditionalFormatting.

Works... sort of...

Big problem is that when the user clicks another field and the
subform loses focus, the selection rectangle on the current
ThingName is lost. Sounds trivial, but visually it's quite
confusing to somebody looking at the screen.


Using a subform isn't a religious issue. Neither is any
specific way of highlighting ThingName. I'll try whatever seems
to work.

The no-brainer would seem tb to revert to a list and do the
highlighting in the detail area. I'd prefer to avoid this,
however, because of the task of managing the highlighting when
the user updates the flag - not that it's all that hard... but
these things seem to pyramid...

Anybody got a workaround? Alternate approach?

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.

 

[(PeteCresswell)]

Per Peter Hibbs:

A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.

That was solid gold.

Thanks!!!!!

 

[(PeteCresswell)]

Per Peter Hibbs:

A Flex Grid Control

Installed MSFLXGRD.OCX into WinNT.System32 and the demo works
A-OK.

But after I set a reference to Microsoft FlexGrid Control 6.0 in
my app and try to drop a FlexGrid onto one of my forms, an error
dialog pops:

"You don't have the license required to use this ActiveX
control...."

Googled those words... but no hits.

??

 

[Peter Hibbs]

Pete.

If you can find a copy of Visual Studio 6 or Visual Basic 6 and
install that then you will automatically get the License.

Alternatively, try importing one of the forms from the demo database
into your project and then modifying the form and code to do what you
want. Make a back up first though, just in case.

If you have plenty of money you could also look at -

http://www.componentsource.com/products/componentone-vsflexgrid-pro/index-gbp.html

for a more comprehensive solution (although I have not tried it
myself).

HTH

Peter Hibbs.

 

[(PeteCresswell)]

Per Peter Hibbs:

If you can find a copy of Visual Studio 6 or Visual Basic 6 and
install that then you will automatically get the License.

Alternatively, try importing one of the forms from the demo database
into your project and then modifying the form and code to do what you
want. Make a back up first though, just in case.

Sounds like it's not part of the MS Access package.

I'm loathe to try an end-run because this thing has to be
installed on some undermined number of user's PC's.

I've got a little .BAT file that I front end it with - and which
checks for the .OCX, copying it down if needed... but I guess I'm
dead in the water license-wise.

 

[(PeteCresswell)]

Per (PeteCresswell):

I'm loathe to try an end-run...

Come to think of it, it seems like if I install VB6 on my
developer box, place the control on the form, then distribute the
app, I'm actually not gaming anybody's system - right?

Seems the same as if it were in a VB6 app: developer has VB6,
places the control, distributes the app.... right?

I'm gonna give it a try.... that FlexGrid is just *too* handy
looking to pass up.

And thanks again for the demo MDB. That was clearly a *lot* of
work - and it's very much appreciated.