where can I find some tutorial stuff to read that will take me from "novice" Access user to say "intemediate level?"
Right here's a great place to start. the microsoft.public.access newsgroups are good as well, that's where I learned the majority of things I know.
I'm especially puzzled over where all of these values (like vbKeyReturn
There's hundreds of thousands of these... you can (from the VB Window) go under View and take a look at the Object Browser, but there's so much information there it's hard to understand it unless you understand it...
One thing that helps me a lot is putting the cursor inside the word (ex. somewhere in vbKeyReturn) and pressing F1 to bring up the VBA help... the help generally has a list of a large majority of these types of enumerations as well as related information. When used correctly, the Help is a massive resource for information.
My next step is to add a bit of color where fields on the screen have missing values. Any advice on setting a text box to a different color. Are there values like vbKeyReturn for setting simple color values?
Me.TextBoxName.Backcolor = vbRed
... highlight vbRed and hit F1 and you should see a list of related enumerations for vb Color constants.
Once you start to get more familiar with how vb names these things, googling them works fairly well also. For instance... "VBA color constants" should return a few links that would give lists on this stuff. The ironic part is that often you don't know what to look for until you find it.