We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Form field contents always selected [closed]

asked 2017-02-12 17:17:11 +0200

DougKMiles gravatar image

updated 2020-09-24 14:02:27 +0200

Alex Kemp gravatar image

This falls into the "hope this is your biggest problem" category, but I created a form with a calculated field in it. Every time I open that form, the contents of that field are selected and highlighted.

I thought maybe changing the tab order might stop it from doing this, but it still opens up selected. I've tried a few other things and nothing changes it.

image description

Any thoughts on how to stop it from selecting this field?

Many thanks! dm

I've attached a sample copy of the data base. The form where this is occurring is called "Long_Stock"

I'm working on a Mac OS 10.10.5, LO version

Thanks in advance for any guidance!


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-24 14:02:39.713949


Could you add the file, or a sample, as an attachment so we can try it too ? If the screenshot shows all of the columns, then there should be no need to anonymize any data. Also, your LO version and operating system release.

rautamiekka gravatar imagerautamiekka ( 2017-02-12 17:23:10 +0200 )edit

There's a ton of data in this entire project. Let me see if I can create a stripped down version to upload. Standby... thanks!

DougKMiles gravatar imageDougKMiles ( 2017-02-12 17:28:54 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-02-12 18:17:40 +0200

Ratslinger gravatar image

updated 2017-02-12 19:02:27 +0200

This appears to be a totals only field which requires no entry or edit. Use this all the time. Change the field properties Enabled to No and Tabstop to No. For appearance I also change Border to Without frame.

Edit: Just looked at you sample. The highlighting comes from the Hide selection property of the field. Change it to Yes.

edit flag offensive delete link more


Thanks Mr. R. Yes, it's a totals field. I did change the field properties as you indicated (including style guide), but it's still coming up with the amount selected.

DougKMiles gravatar imageDougKMiles ( 2017-02-12 18:29:43 +0200 )edit

Sorry for all the editing. Wasn't satisfied with my own answer.

Ratslinger gravatar imageRatslinger ( 2017-02-12 19:03:27 +0200 )edit

Yes! Of course "Hide Selection" Why didn't I think of that? Many thanks!

DougKMiles gravatar imageDougKMiles ( 2017-02-12 19:18:45 +0200 )edit

Same reason it took me three tries! Sometimes we overlook the obvious.

Ratslinger gravatar imageRatslinger ( 2017-02-12 19:57:20 +0200 )edit

Question Tools

1 follower


Asked: 2017-02-12 17:17:11 +0200

Seen: 108 times

Last updated: Feb 12 '17