Access minimizes when clicking hyperlink

[Dale Oswald]

I have a text box on a form whose control source is a hyperlink field. When
I click the hyperlink, the referenced file opens (it is a Word doc), but
Access minimizes. How can I keep Access at its same state/size? I've looked
at the properties of the control but haven't found anything that helped.

 

[Rick Brandt]

I have a text box on a form whose control source is a hyperlink field.
When I click the hyperlink, the referenced file opens (it is a Word
doc), but Access minimizes. How can I keep Access at its same
state/size? I've looked at the properties of the control but haven't
found anything that helped.

Has always behaved that way. PITA ain't it?

Use ShellExecute instead is the only way I have found to avoid it.

http://www.mvps.org/access/api/api0018.htm

 

[DaleO]

Rick, thanks. It helps just knowing the facts. I wonder if I could write an
event process to restore the window?