Recent content by kimperkins1

Sorry, I'm a rookie. Instr only gets me the position of the first hyphen. Do I need to progressively dissect the string to get the count to the second one?

What's the VBA code to return the number of characters between specific characters? For example, I need to find the number of characters between two hyphens - "-xxxxxx-".

Thanks so much. I figured out how to create a Case acTextBox and got it working before your reply. The piece of info I was missing was that the property could be referred to as " ctl.BorderStyle". Your method looks a lot cleaner. I'll try it when I get back in the office.

Probably, if I knew what I was doing. The Function is pasted below. When I try to create another Case acTextBox, I don't know how to refer to the .BorderStyle property as you can see. It works on the individual control, txt400HzType, commented out a few lines later, but not in the Case...

Excellent. I was trying .BorderStyle = "Solid", "Transparent". Now, do you know a way to apply the change to all text boxes at once instead of referencing each one in the code?

I'm a VBA rookie. I have an MS Access form with multiple textboxes. I found how to lock and unlock all boxes on the form via a click event and a Public Function, but I don't know how to change their borders from transparent to solid when they are unlocked.