3 problems help needed: Printing, Security and Formatting

[Adam Harding]

Hi I currently perform a calcualtion on a field to 8 d.p. but as the reuslt
is in £ and pence i only want it to dsiplay to 2 d.p. I can't get this
sorted anyone help?

Number 2 problem is security, i can switch on protection on a form which
limits most stuff BUT it can still be edited by people other than me. I need
to tie this up rigorously for Compliance purposes. Any ideas?

The 3rd problem is to do with fitting the form onto one sheet of paper for
printing and on the screen currently it is 2 and one half page widths. I can
restrict the output by modifying it at the printer BUT as the form is going
to be distributed to all and sundry inside this office, other offices and
homeworkers I do not see how it can be done. I cannot seem to work out a
proper word view either is this one way i could force it to do this?

Many thanks Adam

 

[Jerusik]

Hi Adam,

I don't know if you have solved these problems yet but, just in case you
haven't, here are some suggestions.

1. For your calculation, if you copy your result to a text field and set
your display field to text, you can put the following in the default value of
the display text field:

substring(fieldname, 1, string-length(lname) - 6)

Presuming your calculated field will always contain 8 decimal points, this
will string your field to 2 dp. You must convert the field to text beforehand.

2. An elementary way of securing fields is to add a field to your data
source. Give this field a default value of "1". Place the field on your form.
Hide the field using conditional formatting. You may now use this field to
set other fields to read-only through conditional formatting.

3. Sorry, can not offer any advice on the formatting problem.

Jerusik