Search results

Thanks, I knew about &&, though not about the &_ . I didn't know the spacebar tip. I lashed out wildly at every function key in sight, but the very big key under my nose got forgotten. You've guessed I'm not a professional, haven't you? :D

Well, blow me! Where is that gem of information documented? It solves my problem at a stroke! Thanks Roy-vidar, for coming up with that.

Of course... ...it is possible to use the arrow keys, but to select the first option you have to move to any other option and then back to the first, which introduces the possibility of errors. I'd rather use the appropriate keys if possible.

Apparently not... ... because the form is set up with tab stops that take him from one field to the next in sequence. Pressing the tab key within the option group takes him to the next field, not through the option group. The arrow keys will toggle through the options, but only if a default is...

I have a user who can't operate a mouse and I want to make it possible for him to select from an option group using only the keyboard.This is possible if a default button is stipulated, but can it be done when there is no default? There is no event associated with the keyboard in an option...

Chriso You must have misunderstood me... I was thanking you both for finding the solution, which I tried and which worked. I always do a search before asking questions, but on this occasion had no luck. I also trawled through an Access manual without luck. So your intervention was a godsend...

thanks, both! you can abuse me horribly, as long as you come up with the answers! :)

I want to loop through labels on a form header to check if they are visible, but my syntax isn't working. I am using: For each ctl in Me.Form header If ctl.controltype = acLabel Then...... ....Next ctl But I get an error message: Doesn't support this property or method. Is there another...

Thankyou, I'll give that a try and report back. Thanks for the help.

Docman, Ok, you still have to call the function, but that involves typing 'Call FunctionName' 70 times instead of typing all the control names and colour codes 70 times.! But as I've already done that, perhaps I'll just forget doing it any other way. Thanks for your input.

MaxMangion, I forgot to say..... ....most of the controls are option groups and conditional formatting doesn't work with them. All I really need to know is how to refer to a control on a form from within a function in a standard module. Should I post this in another section?

MSTEF, thanks... ...but I need a generic function I can call from a standard module, so I don't clutter up the form module with masses of code. I know how to do what I want at form level, but, as a VBA beginner,I'm unsure of the syntax for referring to a control in a module.But thanks, anyway.

Please can someone tell me how to change the back colour of a control when it has the focus and then revert to the original colour when it loses it. I have 35 controls on my form, so I need a function, rather than changing the colour with a subroutine evey time. I have searched the site and...