HOW TO VIEW MEMO FIELD IN THE GRID CONTROL?

[Triplex]

Hi,

I used grid in my form, and set all properties such as the record source, control source and others. I can view all the contents of my .dbf in the grid except field (notes) that uses memo field data type. I used textbox control in my grid. How can I view the contents of that field?

If I used plain textbox control and store the value of the memo field type into a variable. I can view the contents of the memo field? How can I do that in grib control?

Thanks

 

[GriffMG]

Hi Triplex,

There are a number of ways, the first is to use the first line of the memo field as the control source instead of the field itself:

thisform.grid1.column1.controlsource="Mline(MyTable.MyMemo)"

Another alternative is to replace the text control with an edit box.

HTH

Regards

Griff
Keep [Smile]ing

 

[ChrisRChamberlain]

Triplex

Because of the physical size restrains of a grid, even using an editbox can make the viewing of a memo field frustrating.

I would suggest you put the following code in the .Click() event of a commandbutton or .DblClick() event of a textbox embedded in the grid.

MODI MEMO MYDBF.notes NOEDIT

The memo field will open in its own window, the coordinates of which will be retained assuming you are using a resource file, and you will have access to the editing and printing functions of the menu, assuming you are using a menu based on the VFP default menu.

FAQ184-2483 - the answer to getting answered.​

Chris