Hi,
format is the property of text box. and u r trying to set the format of the recordset object which it doesn't have. 1st retreive the data in the text box. and 2nd set the format property of the text box.
Bye,
adnan
use this if you use vb6 datareports
------------------------------------
on command button which show report
vname = txtname.text
DataEnvironment1.sprep vname
DataReport2.Show
-----------------------------------------
enter this query in datareport General tab
select * from tablename where...
Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset
dim varQuery as String
-----------------------------------------------------------
With con
.Provider = "microsoft.jet.oledb.4.0"
.ConnectionString = App.Path & "\Table.mdb"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.