Trouble with Continuous Forms and ALSO Conditional Formatting

[JoshuaAnthony]

Hi,

I am hoping to use continous subforms instead of some listboxes to display a few sets of data on a form. Some things that I was wondering however are:
1) Is it possible to remove the title of the displayed field(s) (and if so, how)?
2) Is it possible to remove the record selection buttons as with a normal form? This option doesn't seem to be available to me...
3) Is it also possible to remove the margin next to the first field which contains an arrow pointing to the current record? I'd like to remove this to conserve space and leave the subform looking as similar as possible to the format of a listbox.

The reason I want to use a subform instead of a listbox is so that I can use conditional formatting to highlight individual records. When using conditional formatting, does the field that the condition is based on HAVE to be displayed in the subform? This would mean going back and adding the field into all of my queries. Is it instead possible to base the conditional formatting on a field from the parent form?

Thanks,

Joshua

 

[ghudson]

You need to adjust the subform "format" properties in the design view of the subform.

Record Selectors = No
Navigation Buttons = No

Also, delete the form headers [labels] if you do not want them displayed.

 

[JoshuaAnthony]

Thanks, I also realised I was using 'datasheet' view instead of 'continuous form' which removed the annoying left margin taking up space in the control.

I still can't make the highlighting do what I want though.

I have a form referencing a table with the following fields:
'Job Number', 'Priority', and 'Location'.

I then have a separate (continous) subform (with its own query) displaying 'Job Numbers' for each of the different 'Locations'. I would like to highlight the Job Number according to the 'Priority'. If I use conditional formatting on the 'Priority' field, it only highlights that field rather than the whole record. Can anybody suggest how I might make the subforms perform the way that I want them to?

Thanks,

Joshua

 

[JoshuaAnthony]

Actually, figured it out. Am now using 'expression' in conditional formatting now that I know how to reference subforms:
[Forms]![Form Name]![Subform Name]![Control Name]