Results 1 to 5 of 5

Thread: [RESOLVED] [RESOLVED} Need VBA code to set field's enabled property to "false"

Threaded View

  1. Apr 23rd, 2006, 10:38 PM #1
    carbo
    carbo is offline

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    50

    Resolved [RESOLVED] [RESOLVED} Need VBA code to set field's enabled property to "false"

    I need vba code that will set the enabled property of a field named "Remarks" to "false" if data is present and leave it "true" if it has no data. This is an Access 2000 database (Flat file).

    Thanks

    Carbo

    Solution:

    Private Sub Form_Current()
    If IsNull(Remarks) Then
    Remarks.Enabled = True
    Else
    Remarks.Enabled = False



    End If


    End Sub
    Last edited by carbo; Apr 24th, 2006 at 05:22 PM. Reason: Resolved
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width