Hi,
Question of terminology, control are what you work with on forms, while
fields are what you work with tables. Since a table can exist without a
form, you can have a field without having a control, and since a control can
be bound to nothing, clearly you can have a control without having a field
associated to it.
So, create your form with all the controls to be bind to fields, as usual.
Spot the control with the remark field, click on it, and in the properties,
you should be able to spot the property Visible (third under the tab Format,
for me), set to true. Set it to false to turn the control invisible.
Next, add a NEW control, a text box, call it CombinedRemarkAndSwitch, or
keep it default name, probably something like Text44, no problem as long as
it is NOT the name of an existing field (or another existing control). In
its control source property (first under Data tab, for me), type:
= ( [Remark] + " ") & Switch( 1=1, "hello", 1=2, "What's up doc?" )
and that's all.
Now, since this is a computed expression, the end user cannot edit it. To
allow the end user to edit the remark, somehow, somewhere, at sometime, you
will have to turn the Remark control visible. You can do it, in VBA, with
the statement like:
Me.Remark.Visible = true
(and = false to turn it invisible again, if required). Now, how, when, and
where, is up to you and your user to determine this, first. You can also
'try' leaving the remark control visible all the time, if that is not too
confusing for the end user... or use two forms, one where it is not visible
(read only) for the boss, say, and another form where it is visible, so
someone can work with it, and edit it. So, the boss does not 'work' with it,
just 'look at it', and have his form, and the maintenance, who work with it,
can modify the remark. Sure, if that is the only difference, someone can
create just one form, and open it selectively with the remark control
hidden, or visible, but for a picture about how it 'may' be, it is easier to
do "as if" there was two forms.
Hoping it may help,
Vanderghast, Access MVP
bettyboopbh said:
Hi Michel
i'm sorry to say that as a novice i didn't understand.
"Have the remark control (in the form) bind to the field remark (in the
table) [ HOW ???], but keep it invisible to the end user." --- how???
"To allow the end user to write or modify an existing remark, turn the
remark
control bound to the remark field visible." ???? i'm not sure what to do
here; to me it seem the oppsite of the prior instruction.
the 1st -- "remarks....blind"
the 2nd--"turn the remark control ....visable"
i'm sure someone with a little bit more access knowledge would know how to
follow your instructions, but if you wouldn't mind could you be a little
more
step by step.
your asistance is greatly appreciated.
thanks
Michel Walsh said:
Hi,
Have the remark control (in the form) bind to the field remark (in the
table), but keep it invisible to the end user. Have ANOTHER text control,
visible,with the expression:
=[Remark] & Switch( ... )
To allow the end user to write or modify an existing remark, turn the
remark
control bound to the remark field visible... cause the other control
would
be read only (since it is computed as the concatenation of two
expressions).
Hoping it may help,
Vanderghast, Access MVP
bettyboopbh said:
Hi Michel
i change the control source for the [remarks] control and substituted
the
expression. when i open the form i get '#name' in the remarks field.
when i use the '=switch' by itself as the control source for 'remarks'
i
get
the text i used in the expression (that's good), but i can't add a
remark.
i think your expression is look to get the value from the remarks field
as
if it were a field seperate from the field where we're using the
expression.
it needs to be the same field (or at least look like it's one field
with
the
text msg from the expression and the user's input remarks displayed in
the
remarks field..
i probably was not clear. so i.e. --
to simplify- let say there's only two fields on the form. the 'remarks'
which the user can input to, and the dlookup value. the value of the
dlookuo will determine the msg added to the remarks field. the user
may
or
may not add a remark.
if he does add a remark, both the remark and the text msg from the
expresion
will appear in the remarks field.
thanks
:
Hi,
=Choose( index, "one", "two", "three")
returns the string associated with the position supplied by the index
value
(origin 1), so if index=2, "two", here will be presented.
= Remark & Choose( index, "word1", "word2", "word3")
would concatenate the remark field (which, I assume, hold the remark
made
by
the end user) and the chosen word. If there is no remark, only the
chosen
word would appear.
= Switch( x = "yes", "English", x="sì", "Italian", true, "Unknown" )
is an alternative to choose(), if the values to "test" are not simple
integers. Take a look at the help file for more details.
Hoping it may help,
Vanderghast, Access MVP
i don't want to display the dlookup value. depending on what the
dlookup
value is i want to display a msg in the remarks field
(iif(dllookup="1?
over", "ntfd required","ok")). there will always be some mgs to be
displayed. in adition there may or may not be a user input remark.
if
there
is a remark i need the msg which is based on the dlookup value (not
the
dlookup value) and the remark.
:
Hi,
Something like
Nz( Remark, DLookup( ... ) )
meaning that if there is something in the field Remark, display it,
else,
display the result of the DLookup, which can depends on a criteria,
as
usual. If the criteria in the DLookup is appropriate, it will
change
accordingly to the criteria, and if ever the remark field get
something,
by
the user, then that remark will get the 'priority' and will be
displayed.
Hoping it may help,
Vanderghast, Access MVP
message
i have a control whose source is based on a dlookup. depending on
the
value
returned i wolud like to display a msg in the remarks field on
the
form.
the msg doesn't have to actually be entered as a value in the
remarks
field
and saved in the table. it only has to display to the user in
the
remark
field and not bang into a remark the user wants to enter or a
remark
that
was
entered previously and now because of an edit the dlookup value
has
changed
and a new/different msg posted/displayed.
************************************************************
i'm not sure if i'm being clear, so for those that need an
example:
i.e. lets say on 6/15/2006 the dlookup value is '11 days over',
i
would
like "consecutive days count exceeds permitted limit,
notifications
required." displayed in the remarks field [the limit is actually
10
consecutive days over or 10 consecutive days short]. the user may
have
some
other text he/she needs to enter, which should follow the "
consecutive
days
..." msg.
and
let say that 1 week later the user realizes he made a mistake on
6/12/2006
(not 6/15/2006). when he/she corrects the record, the difference
for
that
day changes from "over" to "short" and therefore the consecutive
count
starts
again at 1 day short. so the mgs for that day will also change.
and
the
dlookup value on subsequent records will change which will/may
affect
the
msg
that needs to be displayed.
in this case, on 6/15/2006 the consecutive days count changes
from
11
over
to 3 over (6/12 was edited and is now short (1day short), and the
next
3
days, 6/13, 6/14, and 6/15 are over (dlookup value on 6/15 = '3
days
over').
so the text msg needs to change to "consecutive days count within
permitted
limit."
(i hope my examples made it better and not worse.)
