Problem with using Column(2) to populate a text box

[kelsita_05]

I have two Combo boxes on a form ([Translator] and [Editor]). They are both based on a query (qrylinguists) that has 4 columns:
Linguists.Name
Linguists.Email
Linguists.Translation Rate
Linguists.Editing Rate

I have the Column Width set to zero, and it works great.

I generate an email off of this form, and I wanted to use the emails from the query, so I made two hidden textboxes on the Form.
Control Source is =Translator.Column(1) and =Editor.Column(1)

Those work great, and show up as they should when I generate my email.

Now I am trying to put the rates in my email. I thought hidden text boxes would do the trick, so I set them up just like the email text boxes:
Control Source is = Translator.Column(2) and =Editor.Column(3)

I set the text boxes to visible to test, but nothing shows up. So I tried putting
Me.trans_rate = Me![Translator].Column(2)
Me.editor_rate = Me![Editor].Column(3)

in the AfterUpdate of the [Translator] and [Editor] combo boxes, but that didn't do anything either. I don't get any errors, but the values do not appear.

There are some null entries in the table the query is based on. Do I have do tell it how to handle those? I tried an Iif function with IsNull, but that just gave me 0 every time.

Once I can get the correct rates to show up somewhere, then I can get them in my email. Any and all help is greatly appreciated!

 

[RuralGuy]

Look into the Nz() function.

 

[kelsita_05]

Good call - but Nz still gives me 0. I ran the query to double check, and the name I am testing with definitely has a corresponding rate. The only thing I can think of that is different is that the Rate fields are currency in the underlying table. Could that be causing the problem?

Thanks!

 

[pbaldy]

Looks like RG is out puttering. What is the column count property of each combo?

 

[kelsita_05]

It's 1 for both of them.

 

[pbaldy]

Since they both have 4 columns, try changing it to 4.

 

[GaryPanic]

see if changing the currency standard works (ie whole numbers - double)

might be currency format throwing a fit

 

[kelsita_05]

the column count did it! Yay! I guess I missed that very important piece of the puzzle. Thank you ever so much - this has been bugging me for a while.

I may change them to the regular number format anyway, as I've run into some other troubles with the currency format too.

Thanks to everyone!