how to programme MS-Access Report with VB code?

Do you mean VBA code ?

I use XP2002. Regardless (not VBA), you will need the Access class library loaded. In coding environment right-click object browser toolbar button, select library references (I think), scroll down to the cluster of Microsoft DLL, select the appropriate object - Access 10, etc. Once that library is loaded you can code the access report object from your module. You'll need a connection object. This will require appropriate admin/owner passwords for the mdb file.

A form is more dynamic than a report. In my opinion, a report is something static that can be sent to a printer.

Having said that, there are events on an Access form. And code can be placed in there to do things like:

onActivate, decide what the recordsource of the report should be. me.recordsource = .....

It may be that you want a textbox to display a global value that you declared as a public variable in a module.

Then me.mytextbox.value = myglobalvariable may occur during the onActivate event. Me. should force access to list all the text boxes, etc. available on the report that you are currently coding.

Do you mean a FORM in MS-Access?

If so, then usually give the control focus and then read or write the appropriate property.

Examples:

'to display HELLO in a text box named txt100

Me.txt100.SetFocus

Me.txt100.Text = "HELLO"

'below is an example SUB to set the backcolor of a label

'the label color may be expressed as a number

Sub setBackColor(ctl As Label, lngColor As Long)

Dim myColor As Long

Dim myControl As Label

myColor = lngColor

Set myControl = ctl

myControl.BackColor = myColor

Set myControl = Nothing

End Sub

I hope that this helps!

yes