Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 What does ByVal actually do ?

Author  Topic 

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2002-05-27 : 08:10:13
I've noticed ByVal used before some variables e.g.

Function Test(ByVal frm as String)

but what does it actually do ?

The help files barely seem to touch on it ?

many thanks
Paul

Paul

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2002-05-27 : 08:20:40
Don't worry i've found it.

It is essentially a copy of the original variable which doesn't actually change the original.

Paul
Go to Top of Page

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2002-05-27 : 08:25:51
Opposite of ByRef which passes in a "pointer" to the object - allowing changes to the object.

--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"
Go to Top of Page
   

- Advertisement -