clear all values in Dbgrid1

User avatar
sal21
PlatinumLounger
Posts: 4355
Joined: 26 Apr 2010, 17:36

clear all values in Dbgrid1

Post by sal21 »

clear all values in Dbgrid1...
how to?
Top
User avatar
HansV
Administrator
Posts: 78483
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: clear all values in Dbgrid1

Post by HansV »

I don't have the DBGrid control, so I can only guess. Perhaps

DBGrid1.Clear

or

DBGrid1.Rows.Clear

or

DBGrid1.ClearFields

or

Set DBGrid1.DataSource = Nothing
Best wishes,
Hans
Top

Return to “VB/VBA/.Net/Office Scripting”