Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Barbara Peisch
  Where is Barbara Peisch?
 Oceanside
 California - United States
 Barbara Peisch
 To: Andy Beebe
  Where is Andy Beebe?
 Bridgton
 Maine - United States
 Andy Beebe
 Tags
Subject: RE: Formatting Doesn't Appear Until Clicked
Thread ID: 78804 Message ID: 78813 # Views: 3 # Ratings: 0
Version: Visual FoxPro 8 Category: Grids
Date: Sunday, October 09, 2005 5:17:00 AM         
   


> I have a grid with currency columns that I have formatted to show 2 decimal places. I have the FORMAT property set to "R" and the INPUT MASK set to $$99,999.99 for the columns. When the form is displayed the columns show all 4 decimal places until you click on them with a mouse, then the formatting appears correctly. I have used the grid in other forms where this behavior doesn't appear, the columns format correctly upon the form start-up.
>
> The grid in question is on a page frame, and I have tried using a this.grid.refresh() in the activate of the page frame without luck.
>
> -- Andy


Did you really enter the formatting into the column or into the textbox in the column? The behavior you describe sounds to me like the Format is in the textbox. Unless you set the column's Sparse property to .F. you only actually see the textbox when the cell gets focus. Otherwise, you see the "raw" column contents. The solution is to either set the column's Sparse to .F. or to set the format in both the textbox and the column.

-BP
www.peisch.com

ENTIRE THREAD

Formatting Doesn't Appear Until Clicked Posted by Andy Beebe @ 10/8/2005 4:47:18 PM
RE: Formatting Doesn't Appear Until Clicked Posted by Andy Kramek @ 10/8/2005 5:08:34 PM
RE: Formatting Doesn't Appear Until Clicked Posted by Andy Beebe @ 10/9/2005 2:22:29 PM
RE: Formatting Doesn't Appear Until Clicked Posted by Andy Kramek @ 10/9/2005 9:17:41 PM
RE: Formatting Doesn't Appear Until Clicked Posted by Barbara Peisch @ 10/9/2005 5:17:00 AM
RE: Formatting Doesn't Appear Until Clicked Posted by Andy Beebe @ 10/9/2005 2:36:41 PM
RE: Formatting Doesn't Appear Until Clicked Posted by Marcia Akins @ 10/9/2005 3:07:46 PM