multi-line text field bonded to variable

[JarekZ]

Hello everyone.
Need some quick help now...

How to put multi-line text field bonded to variable on a form.
I need something like memo field on the form but without the memo field in table. I am constructing form that will be used to insert data to the table and all the input data from users is stored in the variables.

[Stan Mathews]

Re: multi-line text field bonded to variable

How to put multi-line text field bonded to variable on a form.

What seems to be the probem? You can size the variable field on the form as you wish and turn word-wrap on. You just can't use the enter key without it causing you to leave the field.

[JarekZ]

Re: multi-line text field bonded to variable

You just can't use the enter key without it causing you to leave the field.

That's the problem.....

[Tom Cone Jr]

Re: multi-line text field bonded to variable

J, the DBF format isn't equipped to accommodate non alpha or non numeric keys in character fields. It's been that way for a long long time. Use a memo field.

[csda1]

Re: multi-line text field bonded to variable

Or, you can use an XDialog box to capture the input data, and then have XBasic enter the data into the record. With XDialog, you can pretty much do whatever you need.

[JarekZ]

Re: multi-line text field bonded to variable

Or, you can use an XDialog box to capture the input data, and then have XBasic enter the data into the record. With XDialog, you can pretty much do whatever you need.

That sounds like something... but i don't want another window popping-up.
I know that in V9 you can somehow embed xdialog on the for - but i don;t really know how to do that.
Some example of embedded xdialog on the form with variables communicating between the form and xdialog will be really appreciated!

[csda1]

Re: multi-line text field bonded to variable

That sounds like something... but i don't want another window popping-up.
I know that in V9 you can somehow embed xdialog on the for - but i don;t really know how to do that.
Some example of embedded xdialog on the form with variables communicating between the form and xdialog will be really appreciated!

It doesn't have to pop up, it can replace the form entirely. I hav en't used embedded xdialog, but suspect it's the same as a modeless dialog just displayed within the window of the form.

[danh]

Re: multi-line text field bonded to variable

I am not the original poster of this thread, but am after something similar.

I have attached an sample for review. I used an embedded xdialog with the variable bound to a table field. It could be bound to a form var - I think.

What I would like is to get rid of the vertical scroll bar and limit the box to 5 lines, so when the user enters 5 lines or hits enter 5 times, it advances to the next field.

Thanks, Dan

[G Gabriel]

Re: multi-line text field bonded to variable

How to put multi-line text field bonded to variable on a form.
I need something like memo field on the form but without the memo field in table. I am constructing form that will be used to insert data to the table and all the input data from users is stored in the variables.

Skipping through a lot of responses:
1-Put the variable on the form
2-Adjust the width to the desired value, most likely it will be a large number to accomodate multi-lines
3-Check word wrap
4-If you wish to add a hard return within the variable object, use CTRL-Enter

[aschone]

Re: multi-line text field bonded to variable

could you suppress the enter press and return a ctrl-enter instead? Never knew ctrl-enter worked in text boxes, good thing to know.

[G Gabriel]

Re: multi-line text field bonded to variable

could you suppress the enter press and return a ctrl-enter instead?

I am pretty sure you can. I am afraid I am not able to play with this now and others should be able to provide you with a way to do that. I will give you a pseudo code to get you going:

if pressed button is {Enter} .and. if active object is the text object
then
send_keys CTRL-Enter
end if

[gmeredith17]

Re: multi-line text field bonded to variable

You can catch the enter key being pressed with the form onkey event and then use sys_send_keys to replace it with the ctrl enter that Gabriel suggested.

If your type in field object name is field1 then the following will work. Otherwise you will need to change it to your object name and adjust the 7 to the number of characters of your object name +1 to account for the :

I'm sure there is a better way to reference the object and hopefully one of the more experience members will chip in.

' Put this in the form onkey event

active_object= current_object()
active_object=right(active_object, [COLOR="Red"]7[/COLOR])

IF a_user.key.value = "{ENTER}" .and. active_object = "[COLOR="Blue"]:FIELD1[/COLOR]" THEN
	
    a_user.key.handled = .T.

    IF a_user.key.event = "down" THEN
        sys_send_keys("{ctrl-enter}")
    END IF
END IF

For the above code you will either need to turn the tab stop off on all the form objects as it overrides the enter event as a tab. You could turn the tab stop of on all form objects with the onarrive event of field1 and then turn them on again with the on depart. Using this method you would need to trap the tab key when field1 is active and activate a particular object if pressed.

Not sure if the above makes sense but its an idea.

[JarekZ]

Re: multi-line text field bonded to variable

Thank you guys for pointing me to the right direction,
and also for starting other post inside this one ;)

If somebody still care about my (now i know stupid) post i am attaching what i was looking for - multiline textbox bonded with variable (not field form table!)

[danh]

Re: multi-line text field bonded to variable

4-If you wish to add a hard return within the variable object, use CTRL-Enter

What am I missing? CTRL-Enter takes me to the next field unless in change mode, then saves record and goes to new one... same as going to the menu, records and save and enter.

Dan

[G Gabriel]

Re: multi-line text field bonded to variable

What am I missing? CTRL-Enter takes me to the next field unless in change mode, then saves record and goes to new one... same as going to the menu, records and save and enter.

Dan

What I said was not totally correct. It will add a hard return and moves the cursor over to the next field in the tab order. So, to make it work, in your script trap the enter key, translate it to ctrl-enter, return to the previous object and place the cursor at the end of the text.
I wish I had time to play with this, but right now I don't.
Alternatively, and taking advantage of the fact that enter will move you over to the next object in the tab order:
Place several variables on top of each others and make them look like one object. In fact, you could leave the bottom border and that will make them look like several lines.
When you hit enter, it will take you to the next variable.
Concatenate all variables to get your desired variable.
Just a quick idea.