I wrote a vba function to check the fields on my form against a table to determine the validity of the combination of field values. The function is called from each of the field controls and passes its text value and field name. In the function the either text value or the control's value is assigned to a local variable for each control on the form being validated. This function is also called from the form's current record event, but only empty strings are passed to the function. What I'd like to do is make both parameters optional, but the syntax checker won't let me. This seems strange because Excel 2000's vba will let me use optional at the beginning of a function's parameter list. Aren't the two applications using the same core vba engine?

The two applications are both using VBA, but they both have different application models.

What are you trying to do with the optional syntax? What conditions determine whether to run the function or not? I am sure there is a way to do this, but I am not sure what you are trying to do optionally.



mmcdonal

I recently was writing vba code for Excel 2000 and used the optional parameter convention in one of my parameter lists. However, when I tried this in Access 2000, when I added Optional to the beginning of one of my function's parameter list, the editor would highlight the Optional word as an error.

I've written a function to look at the content of the user modifiable fields on my form and determine if they contain valid data in relation to each other. I call this function from each of the exit events of these fields and pass the field's name and its text value. I also call this function from the forms current event and pass in two empty strings.

The function looks at these input parameters and if a field name and text value is passed in then it uses the text value instead of the fields value. When empty strings are passed in then only the field values are used. What I'd like to do is make the field name and text parameters optional, then I wouldn't have to pass in two empty strings. Not a big deal, but I found it strange that the optional parameter didn't work.