Results 1 to 5 of 5
  1. #1
    Amen is offline Novice
    Windows 7 32bit Access 2002
    Join Date
    Sep 2013
    Posts
    19

    Update access Forms and data type

    My Data Type in design view was in "text" format after created my Form, i made a mistake that instead of "text" i should change back to "YE/No"..i have made the changes in design view how can i update that into my Form?...since wen i view my form it still in text box....is there any short cut method


    thanks for your patience



    Regards
    Amena

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,806
    Form in design view, select the control, right click > Change To > make choice.

    Or delete the old control and create a checkbox.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Amen is offline Novice
    Windows 7 32bit Access 2002
    Join Date
    Sep 2013
    Posts
    19
    thanks June7

    when i did the first option only list-box and combo box is visible..i want to select the check-box which is invisible...

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,806
    Okay, then that conversion is not available. Delete control. Create new control.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Amen is offline Novice
    Windows 7 32bit Access 2002
    Join Date
    Sep 2013
    Posts
    19
    June 7..thank you soo much..working fine now..

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

Similar Threads

  1. Replies: 4
    Last Post: 06-20-2013, 12:19 PM
  2. Replies: 3
    Last Post: 05-31-2013, 04:32 PM
  3. Access Query Data Type
    By tmcrouse in forum Queries
    Replies: 1
    Last Post: 07-19-2012, 02:29 PM
  4. Web Forms to Update Access DB
    By GCPDblue in forum Database Design
    Replies: 0
    Last Post: 05-30-2012, 04:50 PM
  5. Replies: 2
    Last Post: 03-18-2010, 08:24 PM

Tags for this Thread

Posting Permissions

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