Changing record types

[rico]

I'm am trying to create a continuous stlye form that displays different
fields for different records, depending on the value of field [service]. I
know that a form set to continuous cannot show hide different field for
different records.

Can anyone think of a way of doing this? Would i have to code the form from
the bottom up? if so how would i go about it? ( basic VB knowledge).

Thanks very much

Rico

 

[Allen Browne]

The continuous form / datasheet in Access cannot display different fields on
different rows.

It is possible to fudge hiding fields by using conditional formatting to set
their forecolor and backcolor, but not to rearrange the form so different
fields appear on different rows.

 

[rico]

Thanks Allen.

So there are no other alternatives?

What about building the form in code for example with vb .net?

Thanks

Rico

The continuous form / datasheet in Access cannot display different fields on
different rows.

It is possible to fudge hiding fields by using conditional formatting to set
their forecolor and backcolor, but not to rearrange the form so different
fields appear on different rows.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I'm am trying to create a continuous stlye form that displays different
fields for different records, depending on the value of field [service]. I
know that a form set to continuous cannot show hide different field for
different records.

Can anyone think of a way of doing this? Would i have to code the form
from
the bottom up? if so how would i go about it? ( basic VB knowledge).

Thanks very much

Rico

 

[Allen Browne]

No, not really other good alternatives.

First thing would be to look at the data structure and see if the field
structure is correct. If you have lots of fields that are infrequently used,
it may indicate that there ought to be a related table with records of
different types instead of lots of fields in this table.

If that is not appropriate, it might be possible to use a text box bound to
an IIf() expression or even a function with a Select Case statement, so that
it displays different things on different rows, depending on the data in
other fields. Set the TabStop property of this to No, and add an unbound
text box that has the TabOrder in the same place, and place it behind the
calculated one (Format | Set to back). In its GotFocus event, copy the data
from the desired field into the unbound text box. In its AfterUpdate event,
copy the data back out to the desired field.

This trick works because the true text box receives focus only in the
current row, so the other rows appear to show the other multiple fields (but
actually the IIf() expression.) It's no substitute for a good data structure
though.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen.

So there are no other alternatives?

What about building the form in code for example with vb .net?

Thanks

Rico

The continuous form / datasheet in Access cannot display different fields
on
different rows.

It is possible to fudge hiding fields by using conditional formatting to
set
their forecolor and backcolor, but not to rearrange the form so different
fields appear on different rows.

I'm am trying to create a continuous stlye form that displays different
fields for different records, depending on the value of field
[service]. I
know that a form set to continuous cannot show hide different field for
different records.

Can anyone think of a way of doing this? Would i have to code the form
from
the bottom up? if so how would i go about it? ( basic VB knowledge).

 

[Rick Brandt]

I'm am trying to create a continuous stlye form that displays
different fields for different records, depending on the value of
field [service]. I know that a form set to continuous cannot show
hide different field for different records.

Can anyone think of a way of doing this? Would i have to code the
form from the bottom up? if so how would i go about it? ( basic VB
knowledge).

Thanks very much

Rico

Do you just need "display" or do you need edit as well. For display only
you can simply use IIf() to display varying fields within the same control
based on your criteria. If you need edit capabilities then it might not be
possible.

Unless... You have all of the "real" controls positioned behind the one with
the IIF() expression and in the GotFocus event of the control with the
expression you use code to set focus to the appropriate editable control. I
don't know what happens to the Z-Order of the other rows when you move focus
to a control in the background though.