A complicated case with continous form

[heroddaji]

Hello, Can anyone help me with this case?
I have to display the working hours of workers in a form ,so I use continuous
form to display those values. the worker have 2 types of working hours, first
is 100% hours, 2nd is 150% hours.
If that guy work only 100%hours, then only show it. if he work also with 150%,
show 2 type of hours, and finally , if he work only 150%hours, show only 150%
hours. Here is an example

name percent hours
-------- ---------- ---------
a 100 8
-----------------------------------
b 100 7
-----------------------------------
c 100 9
150 2
-----------------------------------
d 150 4

my method is I use 2 text box for 100% and 150%, if that worker dont have any
150% hours,i will hide that textbox, so it take me 2 lines to keep 2 textbox
per worker, and make the form look not nice.( for example, if all the worker
have only 100%hours, the 150%hours is still there and take a lot of line).
I want to do something like if the worker dont have that kind of hours, the
line must be not there

my method example
name percent hours
-------- ---------- ---------
a 100 8
//this line is hide, because it have 150%hours textbox , while it support to
be for worker b
-----------------------------------
b 100 7
//this line is hide, because it have 150%hours textbox , while it support to
be for worker c
-----------------------------------
c 100 9
150 2
-----------------------------------
//this line is hide, because it have 100%hours textbox , while it support to
be for 150%hours.
d 150 4

if anyone can help me with this, i really appreciate ...
if my question is not clear, just feel free to ask or email to me.
Thanks.

 

[Dirk Goldgar]

Hello, Can anyone help me with this case?
I have to display the working hours of workers in a form ,so I use
continuous
form to display those values. the worker have 2 types of working hours,
first
is 100% hours, 2nd is 150% hours.
If that guy work only 100%hours, then only show it. if he work also with
150%,
show 2 type of hours, and finally , if he work only 150%hours, show only
150%
hours. Here is an example

name percent hours
-------- ---------- ---------
a 100 8
-----------------------------------
b 100 7
-----------------------------------
c 100 9
150 2
-----------------------------------
d 150 4

my method is I use 2 text box for 100% and 150%, if that worker dont have
any
150% hours,i will hide that textbox, so it take me 2 lines to keep 2
textbox
per worker, and make the form look not nice.( for example, if all the
worker
have only 100%hours, the 150%hours is still there and take a lot of line).
I want to do something like if the worker dont have that kind of hours,
the
line must be not there

my method example
name percent hours
-------- ---------- ---------
a 100 8
//this line is hide, because it have 150%hours textbox , while it support
to
be for worker b
-----------------------------------
b 100 7
//this line is hide, because it have 150%hours textbox , while it support
to
be for worker c
-----------------------------------
c 100 9
150 2
-----------------------------------
//this line is hide, because it have 100%hours textbox , while it support
to
be for 150%hours.
d 150 4

This would be a lot easier to do with a report, not a form, because a report
can use grouping and the Hide Duplicates property to handle this easily. In
a continuous form, I can't think of a way to do it. In single form view,
one could resize empty text boxes on the fly, but that won't work on a
continuous form.

Could you use a report instead? Failing that, can you just make it one line
across for each worker, with the different types of hours in separate
columns?