Skipping optional arguments

[canfish]

Hi everybody,



I have two questions.

First, if I am working with a large function that has 5 arguments, and the 3 arguments in between are optional, how do I "skip" those arguments and only input information about the 5th argument? I am using Allen Browne's concatenate in one field function, and I want to change the string separator, but I can't do that without skipping the arguments in between.

Second, once I figure out how to do that, how do I insert a line break into the argument? I want to concatenate my fields in one function with line breaks instead of commas, so that it is kind of like I have a bullet point list (but without the bullets). Is there a symbol for this, or is there some other method?

Thanks very much!

-canfish

[pbaldy]

There's a pretty decent discussion of how to use optional arguments in VBA help, titled "Understanding named and optional arguments". It also demonstrates adding a line continuation characters (space-underscore) into the declaration.

[canfish]

Thanks pbaldy!

Do you have any idea how to find out what the default values are for each argument? I found that I couldn't leave the optional arguments blank, but I had to put the default code in for Access to accept it. How do I find this default code?

Also, does anyone have some idea how to insert a line break into an argument?

Thanks!

canfish

[pbaldy]

Did you read the help article? You don't have to provide optional arguments, and the line break is demonstrated:

Sub OptionalArgs(strState As String, Optional varRegion As Variant, _ Optional varCountry As Variant = "USA")