Form field prompt when bound to a numeric

[JamesWB]

Hi everyone.

I have several combo box fields in a bound form where they are selecting values from a list (values stored in a separate table) and then loading a number into the bound table field when selected.

How can I put a text prompt in these fields when loading the form which gets removed when focused and of course is not permitted to attempt a save into the bound numeric fields? I've done quite a bit of searching but can only find materials about doing this on bound text fields. I've also seen solutions using Nz which don't seem to work.

Thanks for any help!

 

[spikepl]

Fields do not have prompts and do not appear in a form. Fields are bound to controls that appear in a form. Controls can have a zillion Properties. One of them is Format. In that property type :
@;"enter some value"

 

[JamesWB]

Fields do not have prompts and do not appear in a form. Fields are bound to controls that appear in a form. Controls can have a zillion Properties. One of them is Format. In that property type :
@;"enter some value"

You mean select the control, press F4 and put that expression

@;"enter some value"

in the Format field? Nothing happens.

I checked this page and it just says put the string in quotes and off you go, but again, no effect.
http://msdn.microsoft.com/en-us/library/office/ff198058(v=office.15).aspx

I assume this is because the bound field that the control connects with is numeric?

EDIT OK, I found that the Memo data type referred to above is only for Text Box controls. This is a Combo Box control.

 

[spikepl]

If the combo has value of Null at the beginning then what I gave you works. I presume the width of the first column (the numericaal bound one) is 0, right?

 

[JamesWB]

If the combo has value of Null at the beginning then what I gave you works. I presume the width of the first column (the numericaal bound one) is 0, right?

It's empty at the start, so I assume it has a Null value at load, but is there a way to check that please?

I'm not sure what you mean by 'width of the first column', which property is that in the property list? The column count is 2 and the bound column is 3.