 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / May 2005All Caps Validation Rule
I understand that by typing a > in the format portion of the field properties, it will convert any lower case text entered into upper case. My problem is on export to Excel, it recognizes the original lower case input. I would like the export to also be in all caps. I am sure there is a validation rule, but I cannot find it. Any ideas? Thanks. Just use the UCase function.... either in the AfterUpdate event of the control where the user types in the data, or in a query's calculated field to convert the data for the export.  SignatureKen Snell <MS ACCESS MVP> >I understand that by typing a > in the format portion of the field > properties, it will convert any lower case text entered into upper case. [quoted text clipped - 3 lines] > I would like the export to also be in all caps. I am sure there is a > validation rule, but I cannot find it. Any ideas? Thanks. Thank you, Ken. Appreciate your help. > Just use the UCase function.... either in the AfterUpdate event of the > control where the user types in the data, or in a query's calculated field [quoted text clipped - 7 lines] > > I would like the export to also be in all caps. I am sure there is a > > validation rule, but I cannot find it. Any ideas? Thanks. Ken, Sorry to trouble you again, but after setting up the Macro and then assigning the Macro to the After Update property of the form, I get this error message: "You tried to run a Visual Basic procedure to set a property or method for an object. However, the component doesn't make the property or method available for Automation operations. "Check the component's documentation for information on the properties and methods it makes available for Automation operations." Sorry, I'm stupid. What does this mean???? Thanks. Stacy > Thank you, Ken. Appreciate your help. > [quoted text clipped - 9 lines] > > > I would like the export to also be in all caps. I am sure there is a > > > validation rule, but I cannot find it. Any ideas? Thanks. How did you set up the macro? post the actions / steps. SignatureKen Snell <MS ACCESS MVP> > Ken, > [quoted text clipped - 30 lines] >> > > I would like the export to also be in all caps. I am sure there is a >> > > validation rule, but I cannot find it. Any ideas? Thanks. Ken, The Macro (M_Noun Upper Case) is as follows: Action = Set Value Item = [T_Master Spares Provisioning Record]![Noun] Expression = UCase([Noun]) I then set the After Update Property in the form as follows: After Update = M_Noun Upper Case I don't recall doing anything else. Again, appreciate your help. Stacy > How did you set up the macro? post the actions / steps. > [quoted text clipped - 32 lines] > >> > > I would like the export to also be in all caps. I am sure there is a > >> > > validation rule, but I cannot find it. Any ideas? Thanks. You need to specify that it's a form object in the Item expression: Action = Set Value Item = Forms![T_Master Spares Provisioning Record]![Noun] Expression = UCase([Noun]) Also, if this still isn't working quite right, then try this: Action = Set Value Item = Forms![T_Master Spares Provisioning Record]![Noun] Expression = UCase(Forms![T_Master Spares Provisioning Record]![Noun]) SignatureKen Snell <MS ACCESS MVP> > Ken, > [quoted text clipped - 54 lines] >> >> > > is a >> >> > > validation rule, but I cannot find it. Any ideas? Thanks. > I would like the export to also be in all caps. I am sure there is a > validation rule, but I cannot find it. FWIW I don't think a CHECK constraint, and therefore Validation rule, would work because of Jet's case-insensitive nature. For example, this: CHECK (text_col = UCase(text_col)) would fail to stop lowercase letters, whereas this: CHECK (text_col NOT LIKE '%[a-z]%') would prevent upper- and lowercase :( Jamie. -- I'm not writing to satisfy your question but a.s an MS Access user, your post just gave me an idea. Thanks. > I understand that by typing a > in the format portion of the field > properties, it will convert any lower case text entered into upper case. My > problem is on export to Excel, it recognizes the original lower case input. > I would like the export to also be in all caps. I am sure there is a > validation rule, but I cannot find it. Any ideas? Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.