InfoPath Dev

As I suspected, bizarre behavior must mean a bizarre reason why this was not working, and it was! My tknum field in the SQL table is defined as nvarchar(10), but the length of the field itself is really only 4. When this table is being populated nightly, the data comes in with the tknum, and then 6 spaces. ex: ...

Ernesto, It's not the code. I've commented the code out and still experience the same behavior. I did try your idea of using a SQL view, but once again, the value of the listbox keeps changing as soon as I hit save. The correct value(tknum) is saved to the database. It almost seems like Infopath is trying to add the tknum value to the ...

I have a listbox linked to a SQL Data Connection. My value field is an ID field, tknum. My DisplayName field is FullName, which is an alias field calculated in the Data Connection as LAstName, + FirstName. When I make a selection, and then click Save, the value in the List Box changes to the tknum value of the person I selected. I ...

I got it to work. Just to recap what I did: I added a textbox field. On each button, I set in a Rule 2 things: 1 is to set the value of my textbox field to the letter value of the button that was clicked. And 2, I query my data connection that returns clients(When creating the Data Connection, make sure the 'Automatically retrieve ...

I'm trying to use buttons to populate a ListBox with specific values. I have: Buttons  A  B  C  D  E  F  G  H  I X Y Z  ListBox with Clients Acme, Corp ABC, Corp. What I would like to be able to do is for the user to click on one of the letter buttons, and the listbox would ...

I'm trying to create a Table of Contents on my InfoPath 2007 form. When the form is opened, the form is already populated with a list of users. Ideally, the user will be able to click on a letter at the top of the form, and the form will scroll down to that letter, but staying on the same form. Here's a rough draft of ...

works beautifully. Thanks!!

I'd like to turn off Spelling Checker on my text boxes on an InfoPath form, but the option is disabled under TextBox Properties, Display. I'm using a Secondary Data Source to populate my form and textboxes. Is there a way around this?

I noticed the entire data source did not show up on my screen capture. But under Spouse is: EmpID SignsNameAs Code (which is what I am using to sort) FullNameLast

I've attached it for you, hopefully you can see it. Thanks!