Recent content by Captbob007

Well I've figured that last part out - the code has to be in the module for the form itself, not a 'general' module. Now I am getting an error saying that: "The control or subform control is too large for this location". Unfortunately this doesnt lead me to any help topics...

Ok I have everything set up and am using the code posted above, however I keep getting an error when I click on a label. It comes up with "Invalid use of Me keyword" for the 'SelectTab' Function.. Any ideas what I can do to get rid of that? ~Bob

You say that you "hide the tabs and create your own, using labels". By 'hiding' them do you mean you just set the 'Visible' field to 'no'? I'm trying to get a tab to change color depending on its contents. I have a 'notes' field, and I would like the tab to change color (perhaps...

In design view, change the name of the text box to what you want. In datasheet view the field names take the names of the text boxes that the corresponding data is in... I hope that makes sense.. let me know if it doesn't! ~Bob

I was looking around and I found this thread, which totally helped me out.. Hopefully it answers your question too. Good luck! ~Bob thread703-424049

I think he's trying to do the same thing I am, which is why I figure I'll post here instead of start a new thread. Basically I'm trying to use VBA to set the value of a text box (or maybe label?) before the report is generated. I have one report I'd like to have sorted 2 different ways, and...

Thanks so much! That works fine - I think removing the input mask from the table did the trick, but I changed the SQL as well. It now does exactly what I need!

Nope that's not changing anything either... I even tried taking it up to 7 (like if for some unknown reason the "\" in the input mask were having some effect, even though it shouldn't) It just cant stand that leading zero!

I'm entering numbers like 03-111 or 03-589 and its saving "31-11" and "35-89" in the table...

Kind of the same problem - little different scenario. I have a form that uses an unbound field to input a numeric value into a table (via SQL). In the table, I have it set to be a text field. I have a input mask on the table (00\-000), and the same one on the field on the form, so it looks...