I use a layout that contains either my sale price and my purchased price.

I would like to mask the purchased price because some clients (impressed by FM Database?) are constantly looking to my computer and layout while I register their orders...

I actually masked the field with a colored badge that I put on the field itself, so that I must click in the field to have access to the datas.

But even when I click in any part of the layout, or while executing a script, the badge disappears.

The solution I found so far is to use a color for the text that makes it difficult for someone to read...even for me !

Is there another solution ?

well....

if you turn off allow entry into the field from field format, then place a copy of the field directly on top of that one, and make the text color the same as that of the background.

Now, write a simple one line script that is

Go to field [purchased price]

and on the purchase price field specify it as a button and use this script.

So, because the field has allow entry turned off, it will not show when you click on the layout or in a field. but, you can click it to edit it.

I can't turn off the allow entry because I need to enter the data.

Would it be possible to add to the script "go to the field" another step with redefine step that automatically to turn on the allow entry

Sorry, that is the idea of the script.

It will allow you to enter data, but the field won't show when you enter another field on the layout.

Great. I'll ty this solution

You could also use a separate layout.

Personally, as someone who has worked as a purchaser, I would be frustrated if I always had to click a button to see my all-important cost field.

In my company, we used to have an admin layout and a regular layout for the product database. The admin layout was mostly for purchasers, and the regular layout was mostly for sales people... not showing things they don't need to know (or don't want customers to see).

BTW I know the feeling when customers walk behind you to look at your screen (even when it's clearly an "employees only" area), I can't stand it!

--

Jason Wood

HeyWoody.com