Enter Data into Memo from a Form

[Menglish]

I have avoided using memo fields as they have given me a problem in the past but I need to enter data into a memo field from a form. Everything on my form works fine (designing a proposal for AC company) except the memo field.

From the form I just want to enter the proposal terms, save it and print it up in a report. If I use a browse and enter the data, everything works okay but it would be a little "tacky" to have a customer enter data this way. Any suggestions would be greatly appreciated.

Millard

 

[Mike Gagnon]

Millard

Normaly memo fields are presented on a form with an EditBox. Run the following in a program to see.:

PUBLIC oform1
oform1=CREATEOBJECT("form1")
oform1.Show
RETURN
DEFINE CLASS form1 AS form
      	Caption = "Form1"
	Name = "Form1"
	ADD OBJECT edit1 AS editbox WITH ;
		Height = 181, ;
		Left = 24, ;
		Top = 12, ;
		Width = 301, ;
		ControlSource = "myCursor.release", ;
		Name = "Edit1"
        PROCEDURE Load
		CREATE CURSOR myCursor (release m)
		INSERT INTO myCursor (release) VALUES ("The Visual FoxPro Team at Microsoft"+;
		 "is very excited to announce"+;
		 "that Visual FoxPro 8.0 was completed and released to manufacturing (RTM) on January 31st, 2003.") 
	ENDPROC
ENDDEFINE

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[ramani]

Hi Menglish,

I suggest for your testing something like this..

1. Create your form except memo field, as usual..
2. Drag and drop the Memo field from the data environment in to the form at suitable place and size the edit widow.

If you are using a browse window for other records..
In the AfterRowColChange event of the grid.. add the code..
ThisForm.edtMyMemoField.Refresh()
Suitably change the editbox reference in above. If the grid hilighter is used.. you know you are in which record and the memo field will be availabe for edit easily.

Hope this solves your problem.
ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[Menglish]

Thank you both. That fixed it!!!

Millard