hi

im currently developping a project with ms access 2k and i have some questions about VBA

the 1st thing is the fact, that a from isn't scrolling, if i use the mousewheel, but in the edit-view it works fine. whats wrong? how do i activate the mouse-wheel scrolling for the running application?


2nd:

i created a report with several TEXTFIELDS. nearly each field has its own database sourcefield (like phonenumber, street and so on).
there are only a few fields with combined values like "zip code and city"
for example: datasource=[zip] & " " & [city]

generally it works perfectly for data with an ID>0, but if i want to print a blank report where the source of the database has the ID=0 it only works fine for the "normal fields". these fields are empty, but the combined fields get the value "#error"

i tried several things like writing a modul-function which checks the value of the data (are they empty?) and returns a valid string

but it doesn't help. i think the error happens on accessing the empty data with "[" and "]" and my function is never executed

the next thing i tried was the expression-generator but i am still not able to do what i want.
for example:
there is a function IsError()
i can use it and it returns an 1 if there is an error. perfect.
BUT what now? I am still not able to make a simple if-then-else with the expression generator.
what sould i do?

or better:

how do i make these fields with combined data going to work with an empty source?


and the 3rd thing is that i don't have any ideas how to make a from to be shown maximized.
i tried to call "docmd.maximize" in the onload-function (and some others too) but it doesn't work correctly. when i switch to another dialog (which also should be maximized) and return to the first dialog, the first dialog is not maximized again.

is threre an option to load dialogs maximized per default?



can anybody help me, please?



btw: i think my next project will be a visual c++ project again....