Quick format question

[Peps]

Hi There,

This may be a quick question.. I've got a report in which I have a textbox that has to gater info form a few textboxes

Text88 which is a text
Text89 which is a number "000001"
Text90 which is a text

The Text box that must gather the said info is as below:
=[Text88] & [Text89] & [Text90]

The results are:
AAA1BBB


instead of:
AAA0000001BBB (Which is what I need)

Any solutions out there?

 

[dhookom]

I would change the control names to values that have meaning...

=[Text88] & Format([Text89],"000000") & [Text90]

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Peps]

What can I say but THANKS A LOT.

Peps