Display Social Security # Format in Grid

[crewchiefpro5]

How do I display the correct format of 999-99-9999 in a social security number for the whole column? I have input mask set properly and it will show properly when that row is clicked, but the other rows show just numbers - no dashes.

right now it shows this:
358-99-9870 (correct if I click in this field)
321454545 (all the rest are just numbers)
324565414
321447788



Don Higgins
Crew Chief Pro Racing Analysis Software

http://www.crewchiefpro.com

 

[craigsboyd]

Try setting the sparse property of the column to .F.

http://www.sweetpotatosoftware.com

 

[crewchiefpro5]

Thanks Craig, I saw that an hour after posting the message. Grids are still very new to me.

You think they could have come up with a better name than SPARSE......



Don Higgins
Crew Chief Pro Racing Analysis Software

http://www.crewchiefpro.com

 

[alvechurchdata]

You think they could have come up with a better name than SPARSE

I think it comes from the mathematician's concept of a "sparse matrix" meaning one which has only a very few entries.

Doesn't explain why they chose such an obscure word.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Mike Lewis]

Geoff,

Doesn't explain why they chose such an obscure word.

I suppose if a collection is "sparse", a particular property only applies to relatively few of its members -- in this case, just one. But you're right -- it does seem a bit obscure.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)