1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Ms Access Help

Discussion in 'Business Applications' started by FATMA, Jan 24, 2002.

Thread Status:
Not open for further replies.
  1. FATMA

    FATMA Thread Starter

    Sep 14, 2001
    I have a form in which I have a COMMENT field but I do not want anyone to be able to make changes to the comment that I put in. Besides selecting "NO" to "Enabled" in the field properties, is there anything else that I can do? (I do not want the field to show up grey as it would if I do the above). The database can be accessed by anyone and there is no login required.

    Secondly, how do I get a text field to show up in uppercase only whether a user type in text in lowercase or uppercase?

  2. downwitchyobadself


    Oct 13, 2000
    Set enabled to No, locked to Yes, and the field will not show as greyed out. If you make its background and border transparent, in fact, it can blend right in with your form.

    For the uppercase conversion (good one--had to check it out myself ;)), use the following in input mask for the text box in question:
     < CCCCC 
    (Take the space out, the code function is not working right.) Note that the number of Cs equals a number of characters; the C means any optional character (check Access online help under Input Mask for more details on changing input--there's more info there). If you have more than 5 characters to enter, well then obviously you'll need more Cs
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/66230

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice