LEFT FUNCTION

[rdw1260]

I have a combo box named Combo73. It displays the 2nd column of a query named
IssueCodesQuery. The actual data entered for example is 17.3000 or 01.1000. I
want my report to display 17.3 or 01.1. I have tried using the following in
the control source for the Combo73 with no success.

=LEFT([Combo73],4)

I should also mention that I have another combo control named Combo72 that
displays the 3rd column of the query named IssueCodesQuery. Combo73 and
Combo72 have their control source as: Expr1.

Thanks for the help

 

[Tom Lake]

"(e-mail address removed).(donotspam)"

I have a combo box named Combo73. It displays the 2nd column of a query
named
IssueCodesQuery. The actual data entered for example is 17.3000 or
01.1000. I
want my report to display 17.3 or 01.1. I have tried using the following
in
the control source for the Combo73 with no success.

=LEFT([Combo73],4)

If Combo73 is a numeric field, you could do this:

Format([Combo73], "##.#")

Tom Lake

 

[Ken Snell \(MVP\)]

Use "00.0" as the Format of the textbox that displays the data on the
report.

--

Ken Snell
<MS ACCESS MVP>


"(e-mail address removed).(donotspam)"

 

[rdw1260]

Tom/Ken:

Thanks for both of your responses. Sorry it took so long to reply. Neither
suggestion work. I even changed the field size and then tried both of your
suggestions. I gave up. I reduced the width of the control such that it
displayed 00.0. Anything else I need to check?

Thanks again
--
Bob

Use "00.0" as the Format of the textbox that displays the data on the
report.

--

Ken Snell
<MS ACCESS MVP>


"(e-mail address removed).(donotspam)"

I have a combo box named Combo73. It displays the 2nd column of a query
named
IssueCodesQuery. The actual data entered for example is 17.3000 or
01.1000. I
want my report to display 17.3 or 01.1. I have tried using the following
in
the control source for the Combo73 with no success.

=LEFT([Combo73],4)

I should also mention that I have another combo control named Combo72 that
displays the 3rd column of the query named IssueCodesQuery. Combo73 and
Combo72 have their control source as: Expr1.

Thanks for the help

 

[Ken Snell \(MVP\)]

You want to show the contents of the second column of the combo box in that
textbox? If yes, then the expression needs to be this for the textbox's
ControlSource:

=Left([Combo73].Column(1),4)

--

Ken Snell
<MS ACCESS MVP>


"(e-mail address removed).(donotspam)"

Tom/Ken:

Thanks for both of your responses. Sorry it took so long to reply. Neither
suggestion work. I even changed the field size and then tried both of your
suggestions. I gave up. I reduced the width of the control such that it
displayed 00.0. Anything else I need to check?

Thanks again
--
Bob

Use "00.0" as the Format of the textbox that displays the data on the
report.

--

Ken Snell
<MS ACCESS MVP>


"(e-mail address removed).(donotspam)"

I have a combo box named Combo73. It displays the 2nd column of a query
named
IssueCodesQuery. The actual data entered for example is 17.3000 or
01.1000. I
want my report to display 17.3 or 01.1. I have tried using the
following
in
the control source for the Combo73 with no success.

=LEFT([Combo73],4)

I should also mention that I have another combo control named Combo72
that
displays the 3rd column of the query named IssueCodesQuery. Combo73 and
Combo72 have their control source as: Expr1.

Thanks for the help