Building a Form in VB

[markcrobinson]

I need to display a set of columns beginning with a certain date.


ex. Enter Start date: 052020
ex: Name 052020 062020 072020 082020 092020 ....
In a vb Program I build a SQL statement and create a query.
Works Great:
Set qdf = CurrentDb.CreateQueryDef("DisplayMARS", msqlMARS)
DoCmd.OpenQuery qdf.Name

Problem is, now I need conditional formatting so that entries < 0 are highlighted. Apparently, I can't do that in a query so I built a datasheet form with conditional formatting that displays the query.
... But I can't build the form in vb script, can I?
How can I get the form to start at the date where I need it?

[June7]

Since this is an Access forum, do you mean VBA?
I think it can be done but I wouldn't.
Assign generic names to fields so form or report won't have to be redesigned just because data changes.
Use expressions in textboxes to serve as 'labels'. Use concept described in this link http://www.access.hookom.net/Dynamic...rosstabRpt.htm