InfoPath Dev

or you could create a dummy field then set rules on the check box to change the dummy field to what you want to display, then promote the dummy field to sharepoint instead

You have to bind the check box to a text(string) field, then you can change the properies to say what you want. If the field is a bit field from a database then you have to change the field to varchar in the database and redo your connection Check boxes do not have a format button

i think i see what you mean now, you should be able to display that how you want

I have used the second link and it works great :) I couldnt find a MinusDays() function and that really annoyed me It took me ages to realise you could simply AddDays(-1) lol

ok, what sort of text is in the box and what formatting do you want to do to it?

for text boxes containg number fields you have to open it's properties and click format to change format for text boxes containg text fieild you have to use formatting tool bar like you would in word to change format

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

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