Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    59

    Unanswered: Dbl Clicking to open in form view

    can i change the view of form from datasheet to form view by double clicking a field. plz tell me the code

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Sure...just make sure that the Allow Form View propery and the Allow DataSheet View property is set to Yes then place this code into the Dbl-Click event for the Field on your Form:

    Code:
      Static x As Integer
      If x = 0 Then
         x = 1
         ' Change to Form View.
         DoCmd.RunCommand acCmdFormView
      Else
         x = 0
         ' Change to DataSheet View.
         DoCmd.RunCommand acCmdDatasheetView
      End If
    The code above will allow you to switch back and forth from DataSheet View and Form View. Just keep double-clicking on the same field

    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  3. #3
    Join Date
    Feb 2006
    Posts
    59
    it worked . thakyou

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •