Recent content by Pinecone

Thanks for your help. I am trying to use Axis' solution. I think I got the module set up okay. (I haven't used one in ACCESS before) I have the impression there is a problem in the calling of the module: Me!Address = SetProper(Address) I get the error message: "expected variable or procedure...

It is great to not have to type in caps but I found one gliche in my address line. I type in RR addresses alot and it changes them to Rr. Is there a string operation that can change any occurance in the line of "Rr " to "RR " Thanks in advance Nancy

Works perfectly! Thank you so much. Nancy

I put the code in and made sure the name field was Field1 (because I don't know this aspect of Access) I got it to work once and then it wouldn't let me type anything in the field or delete the contents. This is in the Class Module: Option Compare Database Option Explicit Private Sub...

How do I set a field so that the first letter always defaults to a capital (ie name) so that I don't have to use the shift key when entering data. I found how to default the whole field to caps but ??? Thanks in advance. Nancy

I am printing labels. In some cases the first line is blank or the second line is blank (if there is no company name or no contact name.) How do I skip printing a blank 2nd line or '#error'? There must be an easier way to deal with this common need than some of the methods I've been messing with.