Just a general question.
I'm looking to build a database that houses rich text data. The key is that i need to be able to have a datasheet view in which the rich text formatting shows up correctly. It also needs to work with the "Can Grow" property so that the cells can expand in order show as much text as possible.
Currently this is being done in MS Excel for us. We would like it to have the formatting capabilities of Excel but the power of a database engine.
I only have experience with MS Access and it doesn't allow for the Can Grow in datasheet views. It also doesn't allow rich text or any color formatting.