John,
I seem to recall a long time ago there was an issue with numeric displays with a particular font installed. I assume this is a much later version.
Duane Hookom MVP
MS Access
________________________________
> From: JohnV@msn.com
>
> Not as far as I know. The one example my friend sent me involved
> typing a number on a row in one of the currency fields. The number
> displayed as typed, but disappeared after he saved the row. He's able
> to find the row with a query like:
>
> SELECT * FROM MyTable WHERE MoneyField = 123.45
>
> 123.45 being the value he typed in the row. The query finds the row,
> but displays the field as blank. If there were extra carriage returns
> or stray characters, the query would fail.
>
> John Viescas, Author
>
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> jpjones23@centurylink.net
>
> Has the data been copied and pasted into Excel and/or Notepad from both
> the server and Access to see what is actually in each of the cells in
> question? I've seen this behavior in fields when an unexpected
> carriage return or some other unprintable characters are present.
> ________________________________
>
> From: "John Viescas" <JohnV@msn.com<mailto:JohnV@msn.com>>
>
> I have a friend who has a table on SQL Server with several "money"
> fields. When displayed in a Datasheet in Access (via a linked table),
> the fields show either 0.00 or blank, even though the rows in SQL
> Server contain values. He has tried updating one of the money fields
> (mapped to Currency in Access), and the update appears to go OK on the
> server, but the field goes blank after he saves the record.
>
> Any ideas?
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (11) |
Tidak ada komentar:
Posting Komentar