Hi, Razzak, Let's say I have a field called LOTNO that is TEXT 5 in a DBGrid. If a user enters "30" I want to replace that value with "00030". I'm not sure how the default value in the Table Designer would allow that to happen (but I could be missing something). It looks to me what I need to do is: 1. Find a way to retrieve the value of the field LOTNO in the current row, upon exiting the LOTNO field in the DBGrid. (RBTI_FORM_VARVALUE doesn't seem to work consistently - if the focus is initially in the first column of the DBGrid, the value returned is the field that previously had the focus) 2. Zero fill the value (which I know how to do) 3. Put the zero-filled value back in the LOTNO column of the DBGrid. (I can't see how to do this.) It would seem helpful to make the behavior and properties of the columns in a DBGrid consistent with those of a scrolling region. That way people could retrieve and update a DBGrid column value after exiting a column. It looks like I'll have to go to a scrolling region, which I'd rather not do because of space limitations on my form. BTW, with the Valentine's Day version of V-8, bringing up the BLOB editor for variable memo fields and DBGrid memo fields works wonderfully now with double-click and [SHIFT][F2]. Thank you so much! Diane DeMers In a message dated 1/7/2009 8:17:46 A.M. Central Standard Time, [email protected] writes:
At 12:29 AM 1/7/2009, [email protected] wrote: >I would like to be able to zero-fill a field in a DBGrid on exiting >that field (rather than wait until that row was saved). I know how >to get the value of the field using RBTI_FORM_COLVALUE; however, I >can't quite figure out how to store the zero-filled value back into >the column. > >Is this possible? It's probably obvious but I can't quite see the >solution. Diane, If I understand your question correctly, the best approach to achieve such functionality is to use the "Default" option for that particular column in Table Designer. Hope that helps! Very Best R:egards, Razzak. **************New year...new news. Be the first to know what is making headlines. (http://www.aol.com/?ncid=emlcntaolcom00000026)
