Default Values/Placeholder Text

[rezanaghibi]

Hello there

I am outputting my Access Database to a digital PDF report, and in certain places where fields had no data, those fields don't show up at all. Not only that, but I have to create labels for each field to help with the communication design.

What i am after is a default value inside of a given field. For instance, I have three fields for dimensions labelled Width, Height, and Depth. Not all of my items are 3-dimensional so the Depth part is often blank, but I would like to have something like "00" or "DD" in place of blank.

Thanks in advance, I hope this has made some sense

[ranman256]

you can have zero,
in the query set the field to NZ([field])
this will give a zero instead of null.

[rezanaghibi]

you can have zero,
in the query set the field to NZ([field])
this will give a zero instead of null.

Hmm... perhaps i didnt describe what i was after right...

imagine when you are looking at a form on any webpage. You enter your email address into one box, your phone number into another. But before you enter anything, instead of the boxes being empty, they display things like "your@email.com" or "123-555-4567"

how can I do this?

[ranman256]

each box has a default setting in the property.

[June7]

If you do that, then the record will have the actual text "your@email.com" saved in the field if user does not overwrite. I just use labels to given instructional info like this.

Data controls have ControlTip Text property which I think is intended for purpose of hints to users. I've never used it.