InfoPath Dev

Hi, I have a field that I need to make sure is alpha characters only. I was wondering what I have to do to validate that the field only contains letters and spaces? I can easily make it so that it looks for letters only, but whenever a space is entered, it records it as an error.

Hi, I have a field that concatenates 3 values together separated by a |. I'm using a drop down list to display the concatenated field. Those 3 values are all variable length so I wrote a SQL query that pads in spaces to make it so that they are all the same length and use a fixed length font so that the | line up. It works in SQL and ...