Avatar of Effortless
Effortless
 asked on

DatePicker control in VFP grid doesn't show after picking date and column loses focus.

I am trying to use the Microsoft Date and Time Picker 6.0 ActiveX object in a VFP 9 gridview control. The control works when the cell/column has focus, but I cannot see the value in the cell after the focus moves to the next column. I have tried the SPARSE  property of the column, which hasn't made any difference.

What must I do to see the cell contents after the cell loses focus?

I've attached two images of the cell, one with focus, the other without.

Cell with Date Picker control in focus

Cell when focus has moved to another cell
FoxPro

Avatar of undefined
Last Comment
Effortless

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Pavel Celba

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Effortless

ASKER
Thank you for your help, I did not realize that about ActiveX and Sparse.

I would like to try the two controls solution you suggest as a possible solution - which method/event(s) do you think I could use to set the CurrentControl property of the column? I wanted to try GotFocus on the column, but that doesn't exist...
Effortless

ASKER
Thank you pcelba, I was able to change the CurrentControl in the GotFocus of text1 to OleControl1, and then back to Text1 on LostFocus of OleControl1. This works!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy