I'm using DW CS3, creating datasets from Access 2007/2010 and within access, have the data shown as %.
So, field Output2 (Within Access) = -0.964285714285714 but as a percentage, when set as such, displays -96.4%
When I've created a dataset and then an Update Record Form Wizard creates the page, it displays -0.96428etc instead of -96.4%.
Question: How do I get the data to show -96.4%?
Would I place something here:
<td nowrap="nowrap" align="right">Output2:</td>
<td><asp:textbox id="Output2" text='<%# dsResults1.FieldValue("Output2", Container) %>' TextMode="SingleLine" Columns="32" runat="server" />
This has stopped me in my tracks as I thought that the page would pickup the percentage figure as it's intended and shown within Access
I'm not sure how you are building your pages, but depending on the language you are using there are ways to format strings you pull from a database:
The format of the function will change whether you are using VB or C# and unfortunately DW really does not work well with this anymore. Support for .NET was dropped as of CS4 because of the lack of collaboration between MS and Adobe where the updates to .NET were being lagged to Adobe's products so much that they were almost forced to drop support. So you may have to code this by hand or pick up Visual Web Studio ( http://www.microsoft.com/express/Web/ - link to free express version) to do your programming.