If the data is displayed correctly by stepping through the code, that usually indicated either an error condition that is being ignored, or a timing problem.
Things you could try. 1/ Put a doevents() after the statement that loads the data to the grid. If this fixes the problem, you really need to try and find out what is causing the problem. but at least you have found that it is a timing problem. 2/ Are you trying to display recently added data? i.e. If the Grid is displaying a table of connected workstations and yours is in the list, you will need to allow for the inbuilt delay on displaying new data. Stepping through code often makes this 'problem' disappear because you exceed the delay time while pressing F8 3/ Print out the contents of the returned recordset using debug.print and check that the data appears to be formed correctly, i.e. Null's in unexpected places can cause all sorts of strange behaviours. Matt ----- Original Message ----- From: "Tinashe M Shoko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 31, 2004 4:43 PM Subject: Re: [vbhelp] Datagrid problem - dropping last row > it is truly bound > if i step through code at time it displays all the > records > > --- "Unicorn.PC.Support" > <[EMAIL PROTECTED]> wrote: > > is you grid truly bound, or are you populating in > > manually? > > > > Matt > > ----- Original Message ----- > > From: "Tinashe M" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Sunday, May 30, 2004 9:38 PM > > Subject: [vbhelp] Datagrid problem - dropping last > > row > > > > > > > Hi I have a form I designed with a datagrid bound > > by ado control to > > > an access table. Problem is when I view the > > records on the grid, the > > > last record is always missing even the rowcount > > from code is the > > > number of records selected. > > > > > > Any ideas anyone? > > > > > > > > > > > > > > > > > > > > > '// > > > ======================================================= > > > Rules : > > http://ReliableAnswers.com/List/Rules.asp > > > Home : http://groups.yahoo.com/group/vbHelp/ > > > > > > ======================================================= > > > Post : [EMAIL PROTECTED] > > > Join : [EMAIL PROTECTED] > > > Leave : [EMAIL PROTECTED] > > > '// > > > ======================================================= > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > ===== > ***************************************************************** > As for those pushy metric proponents, give them 2.54cm and they will take 1.6093km!!!!!!!! > ***************************************************************** > ....and Yossarian still could not understand how Milo could buy eggs for seven cents in Malta and sell them for five cents in Pianossa and still make a profit .... > ***************************************************************** > "To the world you might be one person, but to one > person you just might be the world" > ***************************************************************** > SSDD - Stephen King > ***************************************************************** > > > > > __________________________________ > Do you Yahoo!? > Friends. Fun. Try the all-new Yahoo! Messenger. > http://messenger.yahoo.com/ > > > > > > '// ======================================================= > Rules : http://ReliableAnswers.com/List/Rules.asp > Home : http://groups.yahoo.com/group/vbHelp/ > ======================================================= > Post : [EMAIL PROTECTED] > Join : [EMAIL PROTECTED] > Leave : [EMAIL PROTECTED] > '// ======================================================= > > Yahoo! Groups Links > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
