Why cant I drag and drop selected text from a note field into a text box?

[wcook101]

I have a note field where we dump a lot of info scraped off the web, and then we fill in certain fields like address, city, state...etc. Presently all we can do is highlight the text we want and paste it. Its really slow when we could be selecting and dragging. Why is this function not working in Access?

[Bulzie]

Can you give an example of the steps you want to do? So you highlight data from a web page and past it into the Access form and you want to be able to drag data from a webpage to an Access form? Or do you mean inside of Access, you want to drag one field to another field on a form?

[CJ_London]

where else does it work? For access you will need to create a function. Drag and drop functions exist, but they generally work on the whole text rather than highlighted text.

you can identify highlighted text using the selstart and sellength properties of a control. Here is a link to one example for dragging and dropping

https://www.access-programmers.co.uk...-boxes.205498/

[wcook101]

We highlight data (address, city street phone etc..) from a web page, copy it to clipboard, then paste it into a note field in access. Then we populate the address, city, state fields by cut and paste via mouse. What we would like to do is highlight certain pieces of the text in the notes field like the address and highlight and drag it over to the address field and drop it and move on to the next piece of info. but as it stands now i can highlight what I want in the note field but when I left click it to drag it, nothing happens and in fact it looses focus.
Why is that?

[CJ_London]

see this example db - not drag and drop but click and drop with simple code

[wcook101]

Ajax,
that's pretty cool. Nice work around,
One thing I cant figure out is where is the function dropName stored. Its obviously a function, but I cant call it up anywhere. The only place I see it is when I bring up the code for it. Then I find it listed in the general declarations. Im confused. Shouldnt it be available as a custom function?
Im going to use the code if thats ok.. But just for kicks, does anyone know why access doesn't have a drag and drop function from text to text?

[CJ_London]

no idea why not - and I haven't seen it as a standard feature anywhere except on web pages.

good luck

[Missinglinq]

...does anyone know why access doesn't have a drag and drop function from text to text?

Because it's not a word processing program?

Linq ;0)>

[CJ_London]

One thing I cant figure out is where is the function dropName stored. Its obviously a function, but I cant call it up anywhere. The only place I see it is when I bring up the code for it. Then I find it listed in the general declarations. Im confused. Shouldnt it be available as a custom function?

Sorry missed this

the function is a public function (the default if private not declared) and is in the form code module - it could go in a general module, but since it refers to Text6 in the form, would require more work and only beneficial if going to be used in more than one form. If the form was closed, then the function would not be available, but since the form has to be open to call it.......

With regards calling, you will find that on the property sheet events tab, where your would normally expect to see [Event Procedure].

The benefit of doing it this way is a) less code and b) you can select multiple controls and populate the property once.

Aside from above, calling functions this way has other benefits. If the function (or functions) are in a general module, they can be called from anywhere without having to have a form module. Not having a form module means the form will load faster. There are limitations - if your code needs to know things like the position of the cursor over a control, you would use one of the mouse events which returns the XY coordinates as the sub parameters. calling a function can't do that (at least I've never found a way without needing a fair amount of code). You can pass the form as a parameter (equivalent of Me in vba) using [FORM] i.e. =somefunction([Form]) or a control name if you wish =somefunction([myControlName]) or other parameters as required

[wcook101]

Because it's not a word processing program?

Its not? What is it processing?

[Missinglinq]

Let's see...it's a database program...now what could it be processing?

Linq ;0)>