Restoring the position of the Detail section of a form after adding multiple controls

[RonB1949]

I am working on a database to manage my photo collection. I have a form with 32 image controls and associated textboxes. There are more controls than will fit in the Detail without scrolling. When I populate the image controls with images, the whole Detail section of the form scrolls down and hides the first images. How can I programatically restore the Detail to its topmost position?

Thanks in advance

 

[NauticalGent]

Have you tried setting the focus on a control on the header?

 

[CJ_London]

Just to clarify - you have one detail section with 32 image controls? Or a detail section with one image control and 32 rows?

Where are the images coming from? Attachment? File name in a field pointing to a file on disk? Something else?

 

[Gasman]

Set focus to the first image control?

 

[RonB1949]

Have you tried setting the focus on a control on the header?

Set focus to the first image control?

 

[RonB1949]

Sorry setting the focus to a textbox in the header doesn't work and it won't let me setfocus to an image - which seems a bit odd. Thanks

 

[CJ_London]

You can’t set focus to a number of control types including image - look a a controls events- does it have got/lost focus events?

Clarify my questions in post #2 and I might be able to offer an alternative suggestion

 

[moke123]

place a command button up top of your detail, set transparent to yes, and set focus to it.

You can also try positioning the controls on the fly.
something like this:

 

[RonB1949]

You can’t set focus to a number of control types including image - look a a controls events- does it have got/lost focus events?

Clarify my questions in post #2 and I might be able to offer an alternative suggestion

I have one detail section with 32 image controls. The images are loaded from disk via a table in Access. Each set of images comprises the photos I took on a particular day. The image names are in a table with 2 fields - directory (i.e. date) and file name

 

[arnelgp]

can you use webbrowser control?
see sample db in post #12 of this thread:

Access product catalogue website style

Hello everyone, I would need the advice of some of you experts: I run my sporting goods sales business with an Access database, I have thousands of articles, each with its own product sheet, catalogued in categories, subcategories etc. To get a better overview I'd like to create a catalogue view...

www.access-programmers.co.uk

 

[CJ_London]

What if you have more than 32 pictures? And is the table one with 32 columns or so, one for each picture. Or more normalised with 32 rows ( however many actually required) of one picture each?

Given you appear to have a denormalised setup as an alternative to the transparent button suggested, try putting a blank textbox (visible but all dimensions set to 0 in the detail section) and in the form current event set the focus to this control