-
an sql char field will be handled as a string in infopath yes
-
text(string) is the default datatype for most controls
if you add a check box it's default datatype is boolean but you can change it to string from it's properties as shekar said
-
Can you use a char instead?
-
I'll try it. But I don't know if Info path accepts text(string)
-
Stavi,
We are talking about in design mode. It will not format in design mode. You thought we were talking about when we were using it?
-
yes as per the web page i posted, you have to use a web server to convert rich text into a blob field if you want to store it in a oracle database, i think sql version is binary but i dont know for sure
-
you can change the format of texts box in design mode
however the text stored will not have any formatting and you wont be able to change formatting while using the form
-
I think also that the SQL database don't accept Rich Text boxes.
-
oh you can change the display format of number (you are not actualy changing anything, it's just how it's displayed)
By format we both thought you meant rich text, it's rich text that cant be bound to a databse connection
-
TravisBickle,
I deleted that column and place it back under a different name and it worked for me before. Other than that, I don't know what's the problem. It's so strange. I connected to the database with text boxes before and had no problem formatting. I even compared the previous text boxes that worked with the ones that don't and no ...