From the course: Access: VBA

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Set the caption and background picture

Set the caption and background picture

From the course: Access: VBA

Start my 1-month free trial

Set the caption and background picture

“

- [Instructor] The basic forms and reports "Access" creates are just that, basic. If you want to customize them, you can use two of the "Me" object's properties to do so. The "Caption" property controls the text that appears on the form or report's title bar. While the picture property contains reference to the object's background picture. In this movie, I will show you how to use those two properties to control your form or report's appearance. I have opened the course database, and I have opened also the product's report in "Report View". To set the properties that I want using VBA, I need to create an Event Handler for when the report is loaded. To do that, I need to view the report in "Design View", So I right-click it's tab and click "Design View". Now I'll go down to the detail section and right-click a blank spot, and click "Build Event". In the "Choose Builder" dialogue box, I will click "Code Builder", and click OK. When I do, I get an event handler for when the detail…

Contents