edit userform window ms access

Hi Expert's

how would you do the following on a userform.

1. Hide the record display at the bottom
2. Change caption in form window
3. Remove hide minimise and x buttons
4. Add a close button to close the form
route217Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Bill RossConnect With a Mentor Commented:
Hi,

The first 3 items are available on the form property window.  Design the form, click Properties and look for the property
1. Navigation Buttons
2. Caption
3. Min Max Buttons and/or Close Buttons

For your last question you will need to drag the Button on the form.  Select the On Click property and click [Event Property].

Click on the ... to the right in the property line which opens the VBA window.

Enter one line of code as shown below:

Private Sub...
  docmd.Close acForm,me.Name
End Sub

Regards,

Bill
0
 
route217Author Commented:
Thanks bill...excellent


one last point....left hand plane on form not in design view underneath caption
you have a right arrow which u can click how do you remove this
0
 
route217Author Commented:
Found it records selectors....
0
 
Bill RossCommented:
Good.  You're learning fast!
0
 
route217Author Commented:
Hi bill

I have another question open....care to shed some light
0
All Courses

From novice to tech pro — start learning today.