ACCESS FEED: Re: [MS_AccessPros] Customize the forms tab

Rabu, 26 Oktober 2011

Re: [MS_AccessPros] Customize the forms tab

That worked great!

With warm regards,

Arthur Lorenzini
Sioux Falls, South Dakota

________________________________
From: Crystal <strive4peace2008@yahoo.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, October 26, 2011 2:40 PM
Subject: Re: [MS_AccessPros] Customize the forms tab

Hi Art,

try this on the form Loaded event:

'~~~~~~~~~~~~~~~~~~

if not me.newrecord then
me.caption = nz(me.VendorName,"No Vendor Listed")
end if
'~~~~~~~~~~~~~~~~~~

Warm Regards,
Crystal

*
(: have an awesome day :)
*

________________________________
From: Art Lorenzini

I tried something like =[VendorName] and it set it to =[VendorName]

With warm regards,

Arthur Lorenzini
Sioux Falls, South Dakota

________________________________
From: John Viescas

Art-

Set the form's Caption property.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From:Art

I have a database that is set to display in tab mode. I have a form called
frmVendor and want to know if I can adjust the form caption to display the name
of the vendor? [VEndorName].

Thanks,

Art Lorenzini
Sioux Falls, SD

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]