Solved Conditional formatting if field has data

[Sam Summers]

Quick question that i can't seem to find an answer to - is it possible to create a conditional format to make fields in a continuous form visible if a field has data in it?

Thank you in advance

 

[Minty]

Daft question, but surely if there is no data then there is nothing to display?
I'm not sure what benefit "hiding" an empty text box gives you, perhaps you could expand on the process?

 

[Sam Summers]

Daft question, but surely if there is no data then there is nothing to display?
I'm not sure what benefit "hiding" an empty text box gives you, perhaps you could expand on the process?

Ok, well i am using a combobox to to select an item but once the selection is made i hide that and make the data that was selected visible and hide the original combobox but i need to display the selected data in each row of the form.
Hope that makes sense?

 

[arnelgp]

what form are you talking the main form or subform?

 

[Sam Summers]

what form are you talking the main form or subform?

Hi, its all on the same subform on a tabbed form as in the attachment

 

[Minty]

So it looks like you are using an unbound combo - why not bind it to the value, but display the text.
Hide the PK_ID?

 

[Sam Summers]

So it looks like you are using an unbound combo - why not bind it to the value, but display the text.
Hide the PK_ID?

Hi and thank you, I dont know how i would do that as it is a combo with three columns within it to ensure the user selects the correct item ?

 

[Sam Summers]

Right, i managed to solve this by overlaying the box that says 'Angled Finishing Nails' over the combobox that says 'Finishing Nails', leaving the selection drop down arrow clear as in the attachment. This gives the impression of it being hidden but still enables the new record to be selected.

 

[Minty]

Sorry I didn't see your previous reply.

In your combo rowsource you select 4 fields - the three you already have and in front of the PK identifying the data you select.

In the Combo's format property in the column widths select 0cm;2cm;2cm;2cm
This will hide the first column (the PK) but display the other three when dropped down.
When selected it will display the first column that is visible.

 

[Sam Summers]

Sorry for my late reply to close out this thread. What i had was a textbox in front of the cbo that was populated by the selection from the cbo in order to then run a query to insert the selection into a new table 'OnSite' which finally all worked a treat.
Thank you