Results 1 to 6 of 6
  1. #1
    paradise is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    3

    Very simple question about editing a form

    Click image for larger version. 
<br /><script async src=
    Name: access.jpg  Views: 17  Size: 168.4 KB  ID: 8529" class="thumbnail" style="float:CONFIG" />


    Basically its a database we use to track what we do to cust cars in the notes section. I made a Note Contd box but I cant edit it prbable because there is no form to attach it to?

    I didn't create this so I'm not sure how they built the program

    http://www.paradisemotorsbaltimore.c...504/access.jpg

    I can only put in about 200 characters of customer notes.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    What's the control source of that textbox? I would expect to be the name of a field in the table. FYI, a text field can hold 255 characters. You can change it to memo if you need more.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    paradise is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    3
    Thanks,

    But I haven't messed with this program since college about ten years ago. What do I change to "memo" ? The field is bound to a source called "Note".

    Where can I edit the "memo" ?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    You would change the data type of the field to memo.

    The #Name error tells you Access doesn't recognize the field. Can you post the db here?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    paradise is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    3
    tHANKS!!!!!!!!!!!!!!!!!!!!!!!!!1

    I figured it out!!!!

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. A simple question:
    By kosti in forum Queries
    Replies: 4
    Last Post: 10-12-2011, 11:46 AM
  2. Simple Form Question
    By gl2295164 in forum Access
    Replies: 1
    Last Post: 07-31-2011, 09:16 PM
  3. Simple VBA Question
    By koper in forum Access
    Replies: 1
    Last Post: 01-20-2011, 12:07 PM
  4. Simple question?
    By roads.zx in forum Access
    Replies: 0
    Last Post: 10-15-2009, 04:56 PM
  5. Very simple question!
    By fiddley in forum Programming
    Replies: 2
    Last Post: 04-28-2009, 02:16 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