I'm having problem displaying the report, everytime i run it an error pop up "Report width is larger than the paper width". Can someone show me a better way to display report using mysql.

Set conn = New ADODB.Connection
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=localhost;" _
& " DATABASE=test;" _
& "UID=root;PWD=; OPTION=3"
conn.Open

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset

Set VcdReport.DataSource = rs

rs.CursorLocation = adUseServer
rs.Open "SELECT * FROM vcd", conn, adOpenDynamic, adLockOptimistic, adCmdText

With VcdReport.Sections("Section1").Controls
.Item("txtVcdId").DataField = rs("VcdID").Name
.Item("txtTitle").DataField = rs("Title").Name
.Item("txtDirector").DataField = rs("Director").Name
.Item("txtGenre").DataField = rs("Genre").Name
.Item("txtPrice").DataField = rs("Price").Name
.Item("txtStatus").DataField = rs("Status").Name
.Item("txtRentCost").DataField = rs("RentCost").Name
End With

VcdReport.Show