Input mask not showing in report

[Glynn]

I have put an Input Mask "Cash at Bank - "aaaaaaaaa"" in my form to ensure
the user precedes the "aaaaaaa" part of the mask (Bank name) with the title
'Cash at Bank - '.
In the form, this works fine. When the user clicks on to the Control, the
Mask ' Cash at Bank' appears, and the user then enters the bank name in the
"aaaa" section - but - the Mask part does not flow through to the relevant
Table or the subsequent reporting. The Bank Name is captured OK, but the
Mask 'Cash at bank - ' simply dissappears.
I need to force the user to precede the name with the text 'Cash at bank -
', and have other similar situations where I need to force the user to
precede the input with predetermined text.

I don't understand why the Mask does not save into the table for subsequent
reporting. Any help will be appreciated.

 

[Tom van Stiphout]

On Tue, 4 Nov 2008 01:46:07 -0800, Glynn

The reason for not saving is reduction of storage space, and to
provide you with the flexibility of changing the format of the data
without changing the data itself.

You can easily bring it back by putting the formatting in the query
underlying the report:
select "bbbbbbbbb" & MyFieldName as MyColumnName
from MyTable
Sometimes you can also use the Format function:
select Format(MyDateField, "mm-ddd-yyyy")
from MyTable

-Tom.
Microsoft Access MVP

 

[Al Campagna]

Glynn,
If every entry in that field must have the text "Cash at Bank - ", then
there's no need for your users to have to type that each time.
Just have the user enter "aaaaaaa" portion in your form field.
(I'll use the text control name of [AtBank] as an example)
On the form use a label, and the text control...
Label TextControl (AtBank)
Cash at Bank - __________
So... that always "displays" the way you want...

Now, you've stored just the "aaaaaaa" value in your table in the
[AtBank] field.
On the report, just concatenate your desired text string and the AtBank
value...
= "Cash at Bank - " & AtBank

Better to prevent a problem, than code to fix it.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."