|
|
Correctly declaring multiple variables (Access 97-2000) If you want to declare multiple variables in one line of code, be sure to specify the type for each variable, even if the variables are the same type. For instance, avoid code like the following: Dim strFirstName, strLastName, strTitle As String In such a case, only the last variable, strTitle, is actually declared as a String type. The first two variables are created as Variant data types. To correctly declare the three variables, you would use the statement Dim strFirstName As String, strLastName As String, strTitle As String
|