subform enabled puzzle!

[sha7jpm]

right! I am not sure this is possible but will throw it out to the forum in case I am just being pessimistic!

I have a form with a subform. This subform is purely for information purposes. The only interaction I want the user to have with it, is to use a the scrollbar if neccessary.

Therefore I want to remove all enabling from the form, as if it was part of the background.

I have locked the textboxes. that is fine.
but, when you click on the txtbox the cursor can still 'blink' on it..

If I take off enabled, it changes the colour, and ruins the look of the form.

If I take off enabled on the whole subform then I cannot use the scrollbar..

I though of placing a transparent label over the subform upto the scrollbar.. but Access gives priority to the subform, and places the label behind it.

I think I am asking the impossible! a subform that is not enabled except on the scrollbar!!

any ideas?

thanks
John.

 

[AncientOne]

Have you disabled tabbing on all the fields?

 

[IMO]

On the Controls Enabled = No, Locked = Yes

IMO

 

[sha7jpm]

hi

thanks for the advice,

have already tried that I am afraid. What I seem to need is a way to stop the user from selecting the Textboxes, but still able to use the scrollbar..

I think this could be an impossible dream!!

 

[sha7jpm]

cheers IMO

have done that too...

even when the box is locked there is nothing to stop the user clicking on the box, although access wont allow any updates..

this is really a cosmetic issue, but it would just add a nice touch to the form.

what i think I need is a way to place a transparent box over the subform, much in the same way as you would make a custom designed button. the problem is that access make the subform the priority and places everything else behind it..

maybe I could try a transparent subform!
will give that a go...

thanks for the reply.

John.

 

[IMO]

I've just tried with Enabled = No, Locked = Yes on the Controls and it seems to work ok, but you must have both, not one or the other.

IMO

 

[AncientOne]

Blimey, you give up easy!

On the Enter event of your subform put DoCmd.GotoControl "AnyControl on your Mainform"

and the cursor will bounce right back to that control...

 

[AncientOne]

No, that's no good. You need the scroll bar. Put the code on the enter event of each field on the subform...

 

[sha7jpm]

perfect!

that is great,
many thanks indeed!

must not be so pessimistic in the future!!

ta

John.