Results 1 to 4 of 4
  1. #1
    PoorCadaver is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Oct 2011
    Posts
    68

    Designing textbox

    Hi!

    I'm really new with Access and need some help to make my forms look better. I have a table with informatoin about the companies computers (model, IP, Windows version, etc) and want to view the information in a good way.

    I would like it to look like a report (but not a report 'cause I want it to be in a form) so that there are no drop down boxes, but just plain text. I know how to do it with a text box, but then it will only type out the value (wich is connected to another table to view i e Windows version) so then it seems like I lose that function.
    I also don't want to be able to mark the content of the text box.

    So to summorise, How do I write out information from a table in plain text form, converting it from text boxes and drop down lists?

    Jonas

  2. #2
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    Is this what you are trying to do?

    http://allenbrowne.com/casu-15.html

  3. #3
    PoorCadaver is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Oct 2011
    Posts
    68
    Hi and sorry for the late answer!

    Unfortunately, that's not what I meant. I will try to make it more clear.

    What I want is a way of designing a textbox (I think textbox is what I should use) so that it will look like a simple text field without the possibility of marking or editing the content. You could say that it's just a text field I want to use, but then I can't use the values from the drop down list?

    Did I make myself more clear or did I just mess it up even more? =)

    Here is a picture of how I want it to look like:


    Jonas

  4. #4
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    If all you want to do to your form is prevent any updates, then open your form in design view. Click on Properties. Click on Data. For each field that you want to prevent any changes or updates to, change the Locked property to Yes.

    Save your form and reopen it. You should not be able to amend/update any field that has been locked.

    Alan

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help designing a table
    By webfactoryuk in forum Database Design
    Replies: 2
    Last Post: 04-13-2011, 08:39 AM
  2. Designing Reports
    By jlclark4 in forum Reports
    Replies: 3
    Last Post: 02-28-2011, 01:46 PM
  3. Help with designing database
    By nimalp in forum Access
    Replies: 6
    Last Post: 09-15-2010, 10:34 AM
  4. Designing Form
    By Kookai in forum Forms
    Replies: 0
    Last Post: 07-30-2010, 11:03 AM
  5. Help Designing Tables
    By sakthivels in forum Database Design
    Replies: 7
    Last Post: 06-09-2009, 07:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums