Values with number and text

[Mark]

Scenario:
Form: Contain Fields: [Dressing] [Feeding] [PersonalHygiene]
Each of these Fields has a look-up value list combining number and text, and
ranging from 0 to 3. For example the [Dressing Field] has the following
value list: “0 Needs no assistanceâ€; “1 Needs observation/promptingâ€; “2
Dresses with minimal assistance†“3 Needs no assistanceâ€
Objective:
In Forms/Reports, through the use of bound controls to each of these fields,
I want to show the number only of the value selected. I then want a bound
control to these controls that will total the numbers.
Problem:
I used the expression “=Left([Field],1)†in the control source property of
the control that bounds to each of these Fields. This displays the number
only in the control. However, when I try to total these controls in the Total
Control box I get an error message.
Nature of Help required:
As I am not familiar with VBA code I would appreciate that any solutions
suggested will be in the form of Expressions.

 

[Rick Brandt]

Scenario:
Form: Contain Fields: [Dressing] [Feeding] [PersonalHygiene]
Each of these Fields has a look-up value list combining number and
text, and ranging from 0 to 3. For example the [Dressing Field] has
the following value list: "0 Needs no assistance"; "1 Needs
observation/prompting"; "2 Dresses with minimal assistance" "3 Needs
no assistance"
Objective:
In Forms/Reports, through the use of bound controls to each of these
fields, I want to show the number only of the value selected. I then
want a bound control to these controls that will total the numbers.
Problem:
I used the expression "=Left([Field],1)" in the control source
property of the control that bounds to each of these Fields. This
displays the number only in the control. However, when I try to total
these controls in the Total Control box I get an error message.
Nature of Help required:
As I am not familiar with VBA code I would appreciate that any
solutions suggested will be in the form of Expressions.

Your lookup values should have the number and text in separate fields, not
combined. For display on forms and reports it is then trivial to combine them
back together. I would also recommend putting them into a table rather than
using a ValueList and if you have set your current ValueList up in the Table
design you should get rid of that. Lookup tools like ComboBoxes beloing in
forms only, not in tables.

 

[Mark]

Rick,

if you have set your current ValueList up in the Table

design you should get rid of that. Lookup tools like ComboBoxes beloing in
forms only, not in tables.

I have posted a new post today in response to this: (Subject title: Lookup
Values). You wouldn't mind having a look at it please.

Scenario:
Form: Contain Fields: [Dressing] [Feeding] [PersonalHygiene]
Each of these Fields has a look-up value list combining number and
text, and ranging from 0 to 3. For example the [Dressing Field] has
the following value list: "0 Needs no assistance"; "1 Needs
observation/prompting"; "2 Dresses with minimal assistance" "3 Needs
no assistance"
Objective:
In Forms/Reports, through the use of bound controls to each of these
fields, I want to show the number only of the value selected. I then
want a bound control to these controls that will total the numbers.
Problem:
I used the expression "=Left([Field],1)" in the control source
property of the control that bounds to each of these Fields. This
displays the number only in the control. However, when I try to total
these controls in the Total Control box I get an error message.
Nature of Help required:
As I am not familiar with VBA code I would appreciate that any
solutions suggested will be in the form of Expressions.

Your lookup values should have the number and text in separate fields, not
combined. For display on forms and reports it is then trivial to combine them
back together. I would also recommend putting them into a table rather than
using a ValueList and if you have set your current ValueList up in the Table
design you should get rid of that. Lookup tools like ComboBoxes beloing in
forms only, not in tables.